I have multiple Access queries that I want to export into one excel wookbook. I can use the TransferSpreadsheet command, but I can't designate what worksheet to dump the data. Right now all I can think of is making 10 workbooks with one worksheet each and then having another workbook that ties...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.