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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook.Save that also updates XL version?
Ed,
The Save method defaults to the current application's workbook version. You could use: Application.DisplayAlerts = False ThisWorkbook.SaveAs ThisWorkbook.FullName, FileFormat:=xlExcel4Workbook Application.DisplayAlerts = True HTH, Bernie MS Excel MVP "Ed from AZ" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook.Save that also updates XL version?
Thanks, Bernie. That's probably how I'll have to go. I want to SaveAs
an Excel 2003 file - what FileFormat do I use for that? I tried MsgBox ActiveWorkbook.FileFormat and got -4143?? Ed On Mar 24, 3:04*pm, "Bernie Deitrick" <deitbe @ consumer dot org wrote: Ed, The Save method defaults to the current application's workbook version. You could use: Application.DisplayAlerts = False ThisWorkbook.SaveAs ThisWorkbook.FullName, FileFormat:=xlExcel4Workbook Application.DisplayAlerts = True HTH, Bernie MS Excel MVP "Ed from AZ" wrote in ... 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- Hide quoted text - - Show quoted text - |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Workbook.Save that also updates XL version?
Ed,
Using FileFormat:=xlNormal should save the file as the default file type for the Excel version. HTH, Bernie MS Excel MVP "Ed from AZ" wrote in message ... Thanks, Bernie. That's probably how I'll have to go. I want to SaveAs an Excel 2003 file - what FileFormat do I use for that? I tried MsgBox ActiveWorkbook.FileFormat and got -4143?? Ed On Mar 24, 3:04 pm, "Bernie Deitrick" <deitbe @ consumer dot org wrote: Ed, The Save method defaults to the current application's workbook version. You could use: Application.DisplayAlerts = False ThisWorkbook.SaveAs ThisWorkbook.FullName, FileFormat:=xlExcel4Workbook Application.DisplayAlerts = True HTH, Bernie MS Excel MVP "Ed from AZ" wrote in ... 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- Hide quoted text - - Show quoted text - |
Reply |
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 |