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!!
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!!