# Automation Export Wizard to Macro Excel file exporting 0 rows **URL:** \ **Category:** Toad Data Point & Toad Intelligence Central\ **Created:** [July 23, 2020, 2:54pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429 "2020-07-23T14:54:33Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![tellington](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@tellington](https://forums.toadworld.com/u/tellington)\ **Post date:** [July 23, 2020, 2:54pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/1 "2020-07-23T14:54:33Z")
Hello, I have several Automation files with multiple Export Wizard activities that are supposed to export the data into a macro enabled workbook. Each activity is to export its data into a different worksheet within the same workbook. I recently upgraded to 5.1 and now when I run a majority of the Automation files they don't export. I've compared the log files for one of the files that still works against the others and cannot pinpoint the issue. As a test I created an Automation with one Export Wizard activity, and included a SQL I knew had results. When the automation ran it exported 0 rows. So I added a "Select to File" activity and directed it's output to a new worksheet within the same Workbook. It has the exact same SQL as the Export Wizard activity. It exported results but the Export Wizard still did not. Any help would be greatly appreciated. Thank you, Traci E ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [July 23, 2020, 5:53pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/2 "2020-07-23T17:53:36Z")
I am not able to reproduce this issue, at least with the general steps you outline. What happens when you bring up the Export Wizard and select one of the existing Export Template files that had been working before? Do you still get no rows exported? See snap below... ![image](https://global.discourse-cdn.com/quest/original/2X/1/168bef1f3543aa24d76d9e4daf906880e45b2251.png) ---
**Author:** ![tellington](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@tellington](https://forums.toadworld.com/u/tellington)\ **Post date:** [July 23, 2020, 6:31pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/3 "2020-07-23T18:31:07Z")
Yes, I still get no rows exported. ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [July 23, 2020, 7:20pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/4 "2020-07-23T19:20:34Z")
Very strange... I would open a Support ticket so that they can reproduce with your exact steps, Traci. ---
**Author:** ![tellington](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@tellington](https://forums.toadworld.com/u/tellington)\ **Post date:** [July 24, 2020, 1:50pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/6 "2020-07-24T13:50:11Z")
Thank you both so much for responding to me. I was about to submit a ticket this morning and thought I'd look at one more thing. One of my variables was not properly set as a number! Once I fixed that in the script the export worked. I feel so silly having missed that all this time. ---
**Author:** ![Gary.Jerep](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/gary.jerep/32/205_2.png) [@Gary.Jerep](https://forums.toadworld.com/u/Gary.Jerep)\ **Post date:** [July 24, 2020, 4:19pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/7 "2020-07-24T16:19:30Z")
Just checking... so everything works ok now??! ---
**Author:** ![tellington](https://avatars.discourse-cdn.com/v4/letter/t/3be4f8/32.png) [@tellington](https://forums.toadworld.com/u/tellington)\ **Post date:** [July 24, 2020, 5:44pm UTC](https://forums.toadworld.com/t/automation-export-wizard-to-macro-excel-file-exporting-0-rows/50429/8 "2020-07-24T17:44:30Z")
Yes. I can't believe I missed it before.