Save EXCEL 2007 to EXCEL 2003 (1 Viewer)

rickyfong

Registered User.
Local time
Today, 08:20
Joined
Nov 25, 2010
Messages
199
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

Well-known member
Local time
Today, 11:20
Joined
Apr 9, 2015
Messages
4,339
In the SAVEAS command, choose the older format.
Do it in a macro ,then use that code.
 

daniel.smith.10

Registered User.
Local time
Today, 20:50
Joined
May 31, 2017
Messages
10
The simplest route that I know is to do a "Save As..." and tell Excel to save it in the 2003 format
 

Galaxiom

Super Moderator
Staff member
Local time
Tomorrow, 02:20
Joined
Jan 20, 2009
Messages
12,849
Excel can be automated with VBA to iterate through the files in a folder and SaveAs to a different version.
 

Rx_

Nothing In Moderation
Local time
Today, 09:20
Joined
Oct 22, 2009
Messages
2,803
This might also be of interest
Application.DefaultSaveFormat = xlExcel4Workbook

There are different versions of XLExcelXXWorkbook to fill in the XX
 

Users who are viewing this thread

Top Bottom