-
Title
The select Macro screen is blank in the Export Wizard using an Excel .xlsm file. -
Description
Created macros in a Macro-Enabled Excel file (.xlsm) on an outside server. Have Toad Data Point on local box where Microsoft Office is not installed, but using the Toad's Export Wizard to select and use the macros in the Excel file, however in the Select Macro screen, the before and after execution lists are blank and Toad cannot read the macros on the Excel file.
-
Cause
Microsoft Office is not installed on the same box where Toad Data Point is installed. -
Resolution
It is required for Microsoft Excel to be installed on the same client box where Toad is locally installed.
Toad will invoke an Excel COM object in the Export Wizard. Macros are part of the Office VBAScript module and without the macros COM installed, because MS Office does not exist to run any VBA code or edit the Macro enabled file, there is no way for the script engine to initialize and Toad will not populate the macros in the Export Wizard | select the macro section.
NOTE: Also perform a full reboot / restart on your machine after MS Office or Toad installation.