Openning Excel from an Access Form

[Guest]

I'm creating an Excel spread sheet using the TransferSpreadSheet function.
Is the a way I can have the created file open?

 

[Gus]

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