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 Open Document doesn't load Personal Macro Workbook
-
- Posts: 4
- Joined: Wed Sep 26, 2018 8:41 pm
Re: Excel Open Document doesn't load Personal Macro Workbook
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.
It always loads clear document.
When you run Excel from command line then Excel works in its common mode.
Oleg Yershov
-
- Posts: 4
- Joined: Wed Sep 26, 2018 8:41 pm
Re: Excel Open Document doesn't load Personal Macro Workbook
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.
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.
-
- Posts: 4
- Joined: Wed Sep 26, 2018 8:41 pm
Re: Excel Open Document doesn't load Personal Macro Workbook
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?
I need to execute a pre-recorded macro once the Excel file is open.
Is there any way to accomplish this via RoboTask?
Re: Excel Open Document doesn't load Personal Macro Workbook
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
Use Run Program/Open Document action
Next, you have to use Send Keystrokes action to run necessary macro
Oleg Yershov
-
- Posts: 4
- Joined: Wed Sep 26, 2018 8:41 pm
Re: Excel Open Document doesn't load Personal Macro Workbook
I need to execute a pre-recorded macro once the Excel file is open.
Re: Excel Open Document doesn't load Personal Macro Workbook
New version included the action Excel Run Macro.
Oleg Yershov