Hi all,
Some may be familiar with my saga earlier in the day with creating tables/queries.
To sort-of springboard off of that, I'm looking to make each one of the 4 queries I built export to a Microsoft Excel document as separate sheets. When I had the tables, I was able to do this via means of "TransferSpreadsheet" macros I built, however I am unable to do this anymore. I can still export to Excel using "OutputTo" function, but it doesn't create separate tabs on the same spreadsheet like it used to.
Is this something I can do? If so, how would I go about it? I seem to fine woefully little information on this topic.
Thanks, I look forward to your responses!
Some may be familiar with my saga earlier in the day with creating tables/queries.
To sort-of springboard off of that, I'm looking to make each one of the 4 queries I built export to a Microsoft Excel document as separate sheets. When I had the tables, I was able to do this via means of "TransferSpreadsheet" macros I built, however I am unable to do this anymore. I can still export to Excel using "OutputTo" function, but it doesn't create separate tabs on the same spreadsheet like it used to.
Is this something I can do? If so, how would I go about it? I seem to fine woefully little information on this topic.
Thanks, I look forward to your responses!
