Excel - XLBookhandle Using ExecuteFile> Command

[Franklin]

Using XLCreate/XLOpen is actioned via COM so macros within personal & Xlam files not available unless included with existing workbook.

Excel Macros and AddIns can be accessed if the file is opened with ExecuteFile>workbook.xlsx

XLBookHandle is a handle returned when using XLCreate/XLOpen but isn't available when using ExecuteFile>

Questions:
What information does the handle return? looks like it's 1= visible or 0=invisible
Can a variable be created to match the handle information so XL commands can be used?

I tried the code below without success.


Example Code:

Code: Select all

ExecuteFile>myexcelworkbook.xlsx
WindowAction>1, myexcelworkbook*
SetFocus>Myexcelworkbook*
Let>xlbook=1

XlDelRow>xlbook,Sheet1, 1
XlDelCol>xlbook, A:A

Is there an alternative method to get the Excel Addins& Global Macros to work when using Execute File method?

[Dorian (MJT support)]

Use XLGet to attach to an existing running instance of Excel. This assigns it the handle you need to use the other XL commands.

[Franklin]

I am definitely going to reread the MacroScheduler Manual.

Again thank you for your support!

[Dorian (MJT support)]

It's certainly worth going through the command reference one section at a time. That's how I learned it all in the first place. It's grown a lot since then. Plenty of surprises in there!