Running an Excel Macro from personal.xlsb

[Tourless]

Hi Folks.

Can someone tell me if this is possible or do I have to drop my entire macro into my script in order for it to perform its operations on my spreadsheet?

[Dorian (MJT support)]

Yep, that's what XLRun does. (Requires Macro Scheduler Pro/Std v12.0.0.30 or higher).

Code: Select all

XLOpen>d:\Book3.xlsb,1,xlbook
XLRun>xlbook,Macro1

And just to over-egg the omelette, I also discovered something (pointless) which some may find interesting, if you create a second Excel macro which runs the original Excel Macro, you can use XLRunCode to execute it.

In this case Macro2 simply runs Macro1.

Code: Select all

XLOpen>d:\Book3.xlsb,1,xlbook
XLRunCode>xlbook,Application.Run "Book3.xlsb!Macro2"