export to Excel

J

John

Hi, I have an Access 2003 database that sends a multiple parameter query to
Excel using DoCmd.OutputTo acOutputQuery....this works beautifully except
for one thing. I need the spreadsheet to be in 2003 format and not Office95
which is the default. I don't want the user seeing the complicated message
box asking questions about version numbers. How can I save the file
programmatically using VBA from Access, in the Excel2003 format? Each export
method seems to have multiple drawbacks but in this case the OutputTo macro
works great. Is there a way to create the worksheet as Excel 2003 or send a
SaveAs programmatically?

TIA
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using OUTPUT TO in VBA, then how to modify the XLS from Access? 2
DoCmd.OutputTo acOutputQuery acFormatXLS to 97-2003 not 2005 2
Export to Excel 1
Export access query to excel formatted 2
Runtime error 2501 Output to / output Query / excel 8
Excel Export Filtered Form Data To Excel 0
re post: DoCmd.OutputTo into multiple worksheets in excel 2
Exporting to Excel, Set Sheetname 3

Top