Hi again,
I am using a macro to output to an excel file path from a query in Access 2007.
I can get it to write to the correct .xlsx file but is it possible to say what sheet in the .xlsx file you want the output written to?
ie sheet3
Thanks BVG
Hi again,
I am using a macro to output to an excel file path from a query in Access 2007.
I can get it to write to the correct .xlsx file but is it possible to say what sheet in the .xlsx file you want the output written to?
ie sheet3
Thanks BVG
Can you post the code?
Is your code running too slowly?
Does your workbook or database have a bunch of duplicate pieces of data?
Have a look at this article to learn the best ways to set up your projects.
It will save both time and effort in the long run!
Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks