Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 4.0 Macro - Save XLS in Excel 4.0 format?
We have an application written in Excel 4.0 Macro. Within our code we do a
"SAVE.AS (XLSName, 35)". The second parameter 35 indicates that the file should be saved in "MS Excel 4.0 workbook" format. This Save command fails in Excel 2007 but works fine in Excel 2003 and prior versions of Excel. I found a blog http://blogs.msdn.com/excel/archive/...24/718786.aspx that indicated Excel 2007 does not support saving an XLS file in Excel 4.0 format. Does anybody have any idea on what kind of workaround I can have for this problem? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 4.0 Macro - Save XLS in Excel 4.0 format?
There is no reason to save the file in XL4 format unless you plan on opening
it in Excel 4. So just use Excel 97-2003 format: =SAVE.AS(XLSName,1) -- Jim "CdSlc" wrote in message ... We have an application written in Excel 4.0 Macro. Within our code we do a "SAVE.AS (XLSName, 35)". The second parameter 35 indicates that the file should be saved in "MS Excel 4.0 workbook" format. This Save command fails in Excel 2007 but works fine in Excel 2003 and prior versions of Excel. I found a blog http://blogs.msdn.com/excel/archive/...24/718786.aspx that indicated Excel 2007 does not support saving an XLS file in Excel 4.0 format. Does anybody have any idea on what kind of workaround I can have for this problem? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel 4.0 Macro - Save XLS in Excel 4.0 format?
Thanks a lot, Jim. You are a life-saver.
"Jim Rech" wrote: There is no reason to save the file in XL4 format unless you plan on opening it in Excel 4. So just use Excel 97-2003 format: =SAVE.AS(XLSName,1) -- Jim "CdSlc" wrote in message ... We have an application written in Excel 4.0 Macro. Within our code we do a "SAVE.AS (XLSName, 35)". The second parameter 35 indicates that the file should be saved in "MS Excel 4.0 workbook" format. This Save command fails in Excel 2007 but works fine in Excel 2003 and prior versions of Excel. I found a blog http://blogs.msdn.com/excel/archive/...24/718786.aspx that indicated Excel 2007 does not support saving an XLS file in Excel 4.0 format. Does anybody have any idea on what kind of workaround I can have for this problem? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
set Excel 2007 as default to save files in Excel 2003 .xls format | Setting up and Configuration of Excel | |||
Save as file format excel worksheet 4.0 in Microsoft excel 2007 | Excel Discussion (Misc queries) | |||
How do I save an excel file in dbaseIII format in Excel 2007 | Excel Discussion (Misc queries) | |||
How can I save excel files to a DBASE format in excel 2007? | Excel Discussion (Misc queries) | |||
Macro to save excel XP spreadsheet to excel 97 spreadsheet format | Excel Programming |