Writing Excel macros is beyond the scope of this manual; please check your Excel documentation for assistance.
Advanced users of Excel make creative macros that are capable of simple to highly sophisticated operations. If you find something is lacking within ‘Convert XLS’ you can very likely use this special process to extend and enhance its capabilities.
Follow these steps to run a macro of a workbook:
1. Select the special process [114] (*.XLS) Run a Macro from the Special Process drop down list.
2. Next select the input and output files. Output file is only needed if you have chosen to “Save Workbook After Macro Execution”.
Click the Click Here for Run Macro Details button to modify this special processes behavior. Note that you can optionally save the workbook after running the specified macro. Also, you can choose up to 8 parameters/arguments to pass to the macro. Please leave all arguments completely empty (blank) if they are not used, else an error will occur when attempting to run.
The syntax for specifying a macro is:
ObjectName.MacroName
If the macro is located in a separate workbook use this syntax:
‘FullPath’!ObjectName.MacroName
ObjectName can be any defined object with a workbook VBA area such as Sheet1, Sheet2, Module1, ThisWorkbook etc. If specifying a FullPath be certain to add the single quotes. For example this would be a valid entry:
'c:\path\WorkbookWithMacros.xls'!module1.MacroName
3. Optionally click the Add button to add the task to the Conversion Task list. You may add multiple tasks to the Conversion Task list before initiating the conversion process by repeating Steps 1 - 3 as necessary.
4. Click the Convert button to execute the process.