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.
 
Back
Top