| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook.Save that also updates XL version?
A database query program outputs as an Excel 3/4 version file. When I
open in Excel, make any changes and save the file, I get the dialog asking if I want to save in the latest version (I have XL 2003 on my machine). I'm creating a macro to do most of the changes I normally make to these files. Is there anything I can add to the Workbook.Save at the end of ther routine to tell Excel to update the version? Or am I stuck clicking OK every time I run this macro? (I thought of SavesAs, but I don't want a new file - I just want this one saved.) Ed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I save an Excel 97-2003 version or 2007 version for Mac 200 | Excel Discussion (Misc queries) | |||
| Formula updates with SAVE AS | Excel Worksheet Functions | |||
| Macro - Save an Open Excel Version 4 as current version of Excel | Excel Programming | |||
| Open, allow link updates, and Save | Excel Programming | |||
| Workbook.Save not saving the updates | Excel Programming | |||
Threaded Mode
