VBA Exporting Current Excel Version

B

Brent E

Good afternoon,

I setup a macro to transfer (Export) a spreadsheet to Excel. In my macro
settings I set:

Transfer Type: Export

Spreadsheet Type: Excel 8-10. (I select between Excel 3, Excel 4, Excel 5-7,
or Excel 8-10. I assume Excel 8-10 is the most recent version of Excel. I
usually use 8-10)

Table Name: Eastvale Sales Prod Report
File Name:C:\path\filename.xls
Fieldnames: Yes

I then save and run this macro. Export works fine. BUT if I change any data
and save that Workbook, a message box pops up saying
"<filename> is a Microsoft Excel 5.0/95 Workbook, do you want to overwrite
this w/ the latest Excel Format?"

This occurs if I use Excel 5-7 or Excel 8-10 settings.
I also tried using this VBA statement to export
DoCmd.OutputTo acOutputTable, "ESCROW OFFICES",
"MicrosoftExcelBiff8(*.xls)", "C:\DATABASES\Escrow Graph Stats.xls", True,
"", 0

But the same message occurs if saving changes. What do I need in a macro or
VBA expression to export that file in a 2003 version and stop this message
box from appearing? Thanks.

Cordially,
 

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

Top