save as .xls
The UI default and specifying a file extension has no effect. You have to
say what you want, in your case:
FileFormat:=xlExcel8
--
Jim
"Miri" wrote in message
...
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.
--
Miri Tz.
|