SetConnect

ExcelRunMacro

File::ExcelRunMacro
Description

Run one or more macro's in an Excel file.

Note-1: Requires Microsoft Excel to be installed!

Note-2: If you get the following error: "SaveAs method of Workbook class failed" try the following:

On x64: create the following folder: C:WindowsSysWOW64configsystemprofileDesktop
On x86: create the following folder: C:WindowsSystem32configsystemprofileDesktop

Options
Excel file
The MS-Excel workbook (xls file).
Sheet Name
Optional sheet name to run the macro's on. When left empty the default sheet is used.
Macro name(s)
A list of semi-colon (;) separated macro's that must be executed.
Excel output file
Optional excel output file.
Always Overwrite
When checked, will overwrite the outputfile if it already exists.
Auto Create Directories
When checked, will automatically create all directories of the outputfile.
Image resolution
The resolution used to export the images in the sheet.
Include Hidden Sheets
If enabled, hidden sheets will also be exported.

Documentation

Release notes