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.
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.