Hi
I'm using
DoCmd.OutputTo acOutputQuery, "qselAccAnDataToFile", "*.xls", strLoc, False
to output query data to Excel. Works fine. The Excel file is an old file format even though I have Office 2003. If I omit the output format, I'm prompted with a dialogue box which I can select the format...