Return
-
Title
Excel - Export - Macro - microsoft visual basic runtime error 1004 select method of worksheet class failed -
Description
Exporting into excel and running a macro, a macro error shows up:
microsoft visual basic runtime error 1004 select method of worksheet class failed
But, when running the macro manually the error is not there.
-
Cause
Multiple statements in the query to export:
Create table...;Delete ...; ... ;Select ...;
-
Resolution
Put all the others statements in a "Execute Script" activity, before the Export activity, and put only the Select statement inside the Export Activity.