Justin said:
I'm creating an Excel spread sheet using the TransferSpreadSheet function.
Is the a way I can have the created file open?
Hi Justin,
You can try the following if you do not have to use the
TransferSpreadSheet function:
DoCmd.OutputTo acOutputQuery, "qryMyQueryNameHere", acFormatXLS,
"MyOutputFilePathAndNamehere.xls", True
Example with real data:
DoCmd.OutputTo acOutputQuery, "qryExpDailyAvail", acFormatXLS,
"C:\Data\Temp\Daily Availability.xls", True
TheOutPutTo has the option at the end to put a "True" value in the
Autostart section at the end.
See what you think anyway...
Cheers,
Gus
