G
ghinds
Guest
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
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