Excel Open Document doesn't load Personal Macro Workbook

[mikolka111]

Hello,

I have an Excel macro in my personal macro workbook that is automatically imported every time I launch Excel app. The workbook is located at "\Users\(username)\AppData\Roaming\Microsoft\Excel\XLSTART". It loads properly if Excel is started manually or from command line.

However, every time when I open an Excel file from RoboTask using "Excel Open Document" command, the macro doesn't load.

Please help.

Thank you.

[Oleg]

Excel actions uses built-in COM interface of Excel application.
It always loads clear document.

When you run Excel from command line then Excel works in its common mode.

[mikolka111]

Thank you for the reply, Oleg.

Is there any other way for me to load an Excel file from RoboTask so that I can execute the pre-installed macro?

The file is generated daily by a 3-rd party software, and I need to be able to format it in a certain way by using the macro I've created.

[mikolka111]

Thank you for the reply, Oleg.

I need to execute a pre-recorded macro once the Excel file is open.

Is there any way to accomplish this via RoboTask?

[Oleg]

It seems you have to open Excel document from command line
Use Run Program/Open Document action

Next, you have to use Send Keystrokes action to run necessary macro

[mikolka111]

Thanks, Oleg!

[Mokrun]

I need to execute a pre-recorded macro once the Excel file is open.

[Oleg]

New version included the action Excel Run Macro.