RoboTask forum

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.

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.

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.

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?

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

Thanks, Oleg!

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

New version included the action Excel Run Macro.