Macro does not run when selected to do so after exporting data (4242918)

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Macro does not run when selected to do so after exporting data
Description

When exporting to a macro enabled excel file (.xlsm), if a macro is picked to run before or after the export, the macro does not run.
Cause

CAUSE 1: Two different versions of Microsoft Excel are installed on the machine. For example, both 2010 and 2013 are installed.
CAUSE 2: Macro contained a combination of Macro recording and manual vbscript entries. Toad was unable to parse the manual scripting
Resolution

RESOLUTION 1: Uninstall one of the versions of Excel, so only one version of Excel is installed on the machine.
RESOLUTION 2: Where possible, try to use the macro record to replicate the steps

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title