Query output to MSExcel

[ghinds]

I am using DoCmd.TransferSpreadsheet 1, 8, "Query1", "D:\Test\101.xls", True
Query1 needs to be run 55 times with different parameters.
How do I pass these parameters in the VBA? Each query result is saved as a different MS Excel file which I am happy to hardcode the filename for.
Thanks

 

[MikeAngelastro]

What does the first line have to do with the rest of your question?

 

[Fuga]

Since you are thinking of hardcoding the filenames, I take it the parameters won´t be the same all the time.

Where do the parameters come from? a table? The user?

Fuga.