DoCmd Output

[Lyncroft]

Well this seemed to work at home but not in the office. I've got the following code that should send the query toExcel.

DoCmd.OutputTo acOutputQuery, "qryAll", acFormatXLS, _
"G:\Fpit D\a_comp\Dominic\Hoffman\Storage"



When I run it, the status bar tells me its outputting it to Excel but the results don't appear in Excel.

Any ideas?

 

[Lyncroft]

Whoops. I missed out .xls. Only wasted an hour on that one!!!!