I've got some code written to export a bunch of queries into separate tabs on a spreadsheet, and that is working fine. The place were I have having problems is trying to write the code in Access VBA to do a 'save as' on the spreadsheet so I can automate the entire process from Access.

Posted 5 years ago