Problem with export and naming file in macro.

[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.

 

[Ken Snell [MVP]]

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.