Running Excel Macro on CSV

[AndrewT]

So I have a MS script that creates a CSV file that it then opens in Excel with the ExecuteFile command. From there I want to run an Excel macro that is stored in the PERSONAL.XLSB project location. I have tried the XLRun command but nothing happens. I use the XLGet command first to get the handle of the CSV file. I have also tried to use the XLGet command to get the handle from the PERSONAL.XLSB file, but nothing.

Code: Select all

ExecuteFile>%Path%\Amazon Margin Report.csv
WaitWindowOpen>Amazon Margin Report.csv - Excel
XLGet>C:\Users\AndrewT\Documents\Amazon Margin Report.csv,cvbook
XLGet>C:\Users\AndrewT\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB,xlbook
XLRun>cvbook,AmzFormat

Anyone have any ideas?

I know I could convert the VBA in VBScript, but it really isn't worth the effort in this case.

[Marcus Tettmar]

Your code is trying to run a macro in a CSV file, but CSV files do not have macros. I expect you mean to issue the handle for the xlsb file?

[AndrewT]

I have tried the handle for both the CSV and the XLSB, but neither work.

If you use the ExecuteFile command instead of the XLOpen command, then the XLSB file is automatically loaded in the background.