| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to save 2007 file in 97-2003 format
I'm trying to make a macro that will automatically save an Excel 2007 file
in the 97-2003 file format. So far I have this: ActiveWorkbook.SaveAs Filename:=ActiveWorkbook.FullName, _ FileFormat:=xlExcel8, Password:="", WriteResPassword:="", _ ReadOnlyRecommended:=False, CreateBackup:=False The Active Workbook.FullName wants to save the file with the .xlsm extension though the FileFormat=xlExcel8, so I'm confued. Help, please. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 Macro to Open File, Delete Contents, Save New File | Excel Discussion (Misc queries) | |||
| How do I save a 2007 ex file so another party can open with 2003 | Excel Discussion (Misc queries) | |||
| Setting all users to save Excel 2007 files in 2003 format | Excel Discussion (Misc queries) | |||
| save excel file in tiff format in 2007 | Excel Discussion (Misc queries) | |||
| Using Macro to Save xls to txt without changing file format | Excel Programming | |||
![John[_140_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
