Excel 95/5.0

[jump25a]

I want to know what the VB code is to save an excel file as 95/5.0 version. Is there a way to do by changing the FileFormat:=xlNormal line to something else.

 

[Andrew Poulsom]

The FileFormat is xlExcel5 (constant value 39).

 

[jump25a]

For some reason the format xlExcel8 works but xlExcel5 doesn't. I am usung excel version 2007 currently.

 

[Andrew Poulsom]

In what way doesn't it work? And why do you need to save in that format anyway?

 

[jump25a]

When a run my program the follow error message appears:
Run-time error "1004"
Method Save As of Object_"Workbook" failed

When I click debug the folllowing text is highlight:
ActiveWorkbook.SaveAs Filename:= _
fileSaveName, _
FileFormat:=xlExcel5, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

This code works:
ActiveWorkbook.SaveAs Filename:= _
fileSaveName, _
FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _
ReadOnlyRecommended:=False, CreateBackup:=False

The reason I need the window 5.0/95 format is I am importing a excel file into another program and it needs to be in that format