For The Programmers

[Daxton A.]

When using the DoCmd.OutputTo Statement, What is the correct code to use for the Output Format. Say im outputting from a query to Excel spreadsheet. Ive tried .xls, *.xls, (*.xls), "*.xls", ".xls", etc. No Luck yet. If anyone could help with this matter. It would be great.

Thanx,
Daxton

 

[Mile-O]

DoCmd.OutputTo acTable, "tblDiary", "MicrosoftExcel(*.xls)", "g:\ABCDEFG", True, ""