Problem with export and naming file in macro.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am very new to access, but I have been able to create a successful query
and export it into excel. However, my problem is the excel files to be
created are numerous. I want to make a macro for each separate excel
spreadsheet that is needed but I'm having trouble with the macro. When I
insert the runcommand action and export, it asks me to type the file name and
save type. I want that information to be a part of the macro so that I won't
have to type it everytime. Is there a way to do this?

Thank you.
 
Use TransferSpreadsheet action to export your query. It allows you to put
the filename (path and file) into the macro's action as one of the arguments
for TransferSpreadsheet.
 
You must log in or register to reply here.

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

cannot expand named range 1
Export table to txt file with a variable filename 0
Word to Excel: Export comments with text and line number 0
Macro to Export 1
export macro 1
Macro to Export Spreadsheet; Keeps Failing 1
Access Macro to export table to Excel then run Excel macro 1
Export, Copy/Paste and Save with date possible with macro? 2

Back
Top