Opening an Excel file in Access 97

[Sony170]

I created an Excel file using:

DoCmd.OutputTo acOutputQuery, _
"Compile_Query", acFormatXLS, _
"G:\ServiceCompany\SanDiego\Warehouse\LCDLine_Summaries\Daily\" _
& DateMonth & DateDay & DateYear & ".XLS", False

However, after creating this excel file, i want it to automatically open.

Is there any way to do this in 97?

 

[ghudson]

If you had searched the Access VBA help files for the options with the OutputTo method you would have discoverd that all you had to do was change your ending option from False to True. Next time you need more info just select [hi-lite] the VBA command and press the F1 key and the Access VBA help file will open the help file directly to the section that you hi-lited.

DoCmd.[B]OutputTo [/B] acOutputQuery, _
"Compile_Query", acFormatXLS, _
"G:\ServiceCompany\SanDiego\Warehouse\LCDLine_Summa ries\Daily\" _
& DateMonth & DateDay & DateYear & ".XLS", [B][COLOR=Blue]True[/COLOR][/B]