Getting the right version for Excel export

C

Chris Freeman

I'm exporting an acees Table to an Excel file. At first I used the OutPutTo
code:
DoCmd.OutputTo acTable, stDocName, "MicrosoftExcelBiff10(*.xls)", "test
outputto.xls", True, "", 0

This works great, opens a dialog box so I can choose where to save, but when
the file opnes, its version 95/7.0. Then I have to save it as a current
version .xls

Next I use Transfersheet:
DoCmd.TransferSpreadsheet acExport, 8, stDocName, "" & stDocName & "", True,
""

This works to save it in the current Excel format, but does not allow for a
dialog box.

How do I code for a dialog box so I can do a SaveAs and use the current
Excel version format?
 

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

What is equivalent to "acSpreadsheetTypeExcel9" in 2007 i.e .xlsx 0
Export Report with Graph to Excel error 2495 1
Word macro that can call cells out of Excel for a find and replace 0
Exporting a Report to Excel 2
Macro Code for bringing up Save As dialog box and changing file Type 0
Export to Excel with Parameter in Filename 1
Getting query into Excel 1
VBA code issue...Would love expert help. 5

Top