| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - Save an Open Excel Version 4 as current version of Excel
I'd like to open some excel files that are created in Brio - which saves in Excel 4 format - and them save them in the current excel version from a macro. Can anyone give me advice? I tried recording a macro but it doesn't seem to add in the extra part about saving in new version of Excel. Thanks in advance. Pete |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Macro - Save an Open Excel Version 4 as current version of Excel
ActiveWorkbook.SaveAs activeworkbook.FullName, xlWorkbookNormal
-- Regards, Tom Ogilvy "planomax" wrote: I'd like to open some excel files that are created in Brio - which saves in Excel 4 format - and them save them in the current excel version from a macro. Can anyone give me advice? I tried recording a macro but it doesn't seem to add in the extra part about saving in new version of Excel. Thanks in advance. Pete |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Saving a newer version of Excel using an older version (Excel 97) | Excel Discussion (Misc queries) | |||
| How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
| Help Required!!! Macro to load data from version 1 to version 2 | Excel Worksheet Functions | |||
| Recover earlier version of excel sheet after new version saved? | Excel Discussion (Misc queries) | |||
| How can I update the version of Excel 2000 9.0 to version 10.0 | Excel Discussion (Misc queries) | |||
Linear Mode
