Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
save as .xls
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save As and save current numbers not the actual formulas and links | Excel Discussion (Misc queries) | |||
Command Button Save As Application.ExecuteExcel4Macro ("SAVE.AS?() | Excel Discussion (Misc queries) | |||
how to get disk icon on save button of save as dialog like 2000 | Excel Discussion (Misc queries) | |||
when i save xls file, debug script is running and canno't save fil | Excel Discussion (Misc queries) | |||
Save Excel file - prompts to save - no Volitile functions used | Excel Worksheet Functions |