Activeworkbook.Saveas (FileFormats)

[purceld2]

I am using the above command in some VBA code and it is saving the spreadsheet in Excel 5.0/95 Format I am using defaults.

I understand I can use FileFormat:=

what value will give me Excel 2003 format

Thanks in advance

Line of Code below

xlObj.activeworkbook.saveas "c:\documents and settings\802284714\My Documents\PC Data\Supplier Gate Call 4.xls"

 

[James Dudden]

Have you tried changing the reference?

To do this, open the Visual Basic page and on the menu click Tools/References - I have Microsoft Excel 11.0 Object Library selected and this saves mine in 2003.