How to Change the File Name for an Export Query as Excel Macro

G

GeyikBaba

In Access 2003, I have a macro which generates and saves an Excel
spreadsheet using a select query. The spreadsheet is saved in the default
output directory, the name of the file is the same as the name of the query.
So if the query is named 'query1', the spreadsheet will be named
'query1.xls'.

I had a problem yesterday where a user tried to generate two spreadsheets,
one after the other. Of course, the second 'query1.xls' overwrote the first
'query1.xls'.

Right now, I am executing the macro as follows:

DoCmd.OPenMacro "macroname"

Is there any way I can expose the macro in VB and provide it with a custom
name for the spreadsheet?

Many thanks
Mike Thomas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Merging from an Excel file with graphics 1
Excel buttons change macro file name when run on other computers 7
Modify A Query Again 1
How to Write EXCEL files from a FORTRAN Program ? 0
Need to export multiple files 3
Output to : Template file 3
Word 365 is saving great to Dropbox, but upon rebooting next day, Word does not show the file I last saved. 0

Top