File Format of EXCEL 2007 (1 Viewer)

rickyfong

Registered User.
Local time
Yesterday, 19:13
Joined
Nov 25, 2010
Messages
199
ActiveWorkbook.SaveAs Filename:="D:\TO2007" & str3 & ".xlsX", _
FileFormat:=xlExcel14, CreateBackup:=False


I used to work with 2003, but one customer would like to have an Excel in 2007 format. I used 2007 version to open a 2003 Excel sheet. The above VBA is trying to save the EXCEL sheet automatically to 2007 format! I have tried a lot of fileformat value, but none of them given me the correct 2007 file format when I tried to open the saved Excel sheet!! Any idea?? Thanks a lot!!
 

Gasman

Enthusiastic Amateur
Local time
Today, 02:13
Joined
Sep 21, 2011
Messages
14,048
Using macro recorder in Excel 2007 and saving a file gives the code below

Code:
FileFormat:=xlOpenXMLWorkbook
 

Rx_

Nothing In Moderation
Local time
Yesterday, 20:13
Joined
Oct 22, 2009
Messages
2,803
Not sure, but suggest looking at the Excel Object Model (F2 Object Browser in code module) to determine if the object model for charts or other objects changed.
Seem to remember there was a change at some point, but that was too long ago.
 

Users who are viewing this thread

Top Bottom