XLRun

Technical support and scripting issues

Moderators: Dorian (MJT support), JRL

Post Reply
fightcancer
Macro Veteran
Posts: 253
Joined: Fri Apr 15, 2005 8:32 am

XLRun

Post by fightcancer » Tue Oct 08, 2024 2:18 pm

FYI, XLRun doesn't work as intended when there are spaces in the macro name.

Does Not Work:
XLRun>xlBook,Excel Addin Macros.xlam!test3

Does Work:
XLRun>xlBook,ExcelAddinMacros.xlam!test3

(This test used 2 different MS Excel Addin files with the filenames above.)

User avatar
Grovkillen
Automation Wizard
Posts: 1131
Joined: Fri Aug 10, 2012 2:38 pm
Location: Bräcke, Sweden
Contact:

Re: XLRun

Post by Grovkillen » Tue Oct 08, 2024 4:40 pm

Tried this?

Code: Select all

Let>TEMP_macro_name=Excel Addin Macros.xlam!test3
XLRun>xlBook,TEMP_macro_name
Let>ME=%Script%

Running: 15.0.27
version history

fightcancer
Macro Veteran
Posts: 253
Joined: Fri Apr 15, 2005 8:32 am

Re: XLRun

Post by fightcancer » Tue Oct 08, 2024 8:52 pm

I haven't. Good idea.

Post Reply
cron
Sign up to our newsletter for free automation tips, tricks & discounts