I'm trying to export data from SQL server into an excel table using VBA. At the moment the tables are connected to the server and I have a macro that pulls the data in;

Please Login or Register  to view this content.
I want to be able to run the two tables seperately, so I insert the first table, insert 2 rows, then insert the second table.
Are there any ideas on how to do that??

Thanks