save as .xls

  • Thread starter Thread starter Miri
  • Start date Start date
M

Miri

hi,
i'm working with excel 2007.
i set in the excel option, the option "save files in format" with the value
"excel 97-2003 workbook(.xls)".
but still, when i create a new file via macro, and use the following:
Workbooks.Add.SaveAs FileName:="bla_bla.xls"
or
Workbooks.Add.SaveAs FileName:="bla_bla.xls"
FileFormat:=XlFileFormat.xlWorkbookDefault
it still save the file with the .xls extention but under as .xlsx type.
please help.
 
The UI default and specifying a file extension has no effect. You have to
say what you want, in your case:

FileFormat:=xlExcel8
 
Back
Top