How do I output to multiple Excel files with different schemas

[ChrisCrombie]

I posted this as a reply to another thread, but I thought I'd put it out there to the general community as well to see if anyone has any ideas. 

I'm trying to create a batch macro to read a list of SQL Server table names and specify backup file names for them to be written to.  The sheets in the backup excel files will be the names of the SQL tables.

I can get this to run on a single pass no matter what the schema is, and I can get the workflow to run the macro successfully, but the files are not getting written.  I have no idea what's happening since I can't see what the macro is actually doing (maybe there's a way to see into this?).

Anyway, any help would be appreciated.  I've attached the test files.

Thanks!  Chris.

[sfyodor]

Not sure if this will help, but I use something like below where I use a formula tool to create an excel tab with a specific name, and then table and layout tools to render that tab with data into separate excel files. You can also use union tool after table tool to create one excel file with multiple tabs with different names if needed.    

[ChrisCrombie · Accepted solution]

Thanks for the reply sfyodor. 

Actually, I found the problem after I posted.  Sometimes the simplest solution is not making silly errors like I did.  I had the "Disable All Tools that Write Output" selected in Runtime for testing [insert picture of me smacking my head here].

It's working fine now and I'm going to go ahead upload the corrected version for posterity in case anyone else can benefit.

Chris