Save EXCEL 2007 to EXCEL 2003

[rickyfong]

In an application, I used to download 5 to 6 EXCEL 2007 files to work. Then, my ACCESS 2003 only can upload EXCEl 2003 files. Just want to know, besides the manually saving lower version in EXCEL, is that any VBA or MARCO in EXCEL which can automatically all EXCEL 2007 to EXCEL 2003 file format!! Of course, I could predefined any coding in downloaded file as they are all generated at once by that application! Thanks a lot!!

 

[Ranman256]

In the SAVEAS command, choose the older format.
Do it in a macro ,then use that code.

 

[daniel.smith.10]

The simplest route that I know is to do a "Save As..." and tell Excel to save it in the 2003 format

 

[Galaxiom]

Excel can be automated with VBA to iterate through the files in a folder and SaveAs to a different version.

 

[Rx_]

This might also be of interest
Application.DefaultSaveFormat = xlExcel4Workbook

There are different versions of XLExcelXXWorkbook to fill in the XX