Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as new file without changing existing file
Lets say an excel file A.xls has been opened and has had some changes made
to it but not saved. Is it possible in VBA to save this file as B.xls including the changes and have file A.xls still open in excel so that if the file were to be closed you could still select to save the changes or not? Thanks Clayton |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as new file without changing existing file
You can use SaveCopyAs with code to save the file in the folder you want and with the name you want
ThisWorkbook.SaveCopyAs "C:\Data\yourfilename.xls" -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mcphc" wrote in message ... Lets say an excel file A.xls has been opened and has had some changes made to it but not saved. Is it possible in VBA to save this file as B.xls including the changes and have file A.xls still open in excel so that if the file were to be closed you could still select to save the changes or not? Thanks Clayton |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as new file without changing existing file
Unfortuantly what I want is not that simple.
I basically want a macro that works just like an auto save works. So if I run the macro a file "B.xls" is saved which is a snap shot of what the file "A.xls" currently is. Then if I close file "A.xls" I am still asked if I would like to save my changes before closing. "Joel" wrote: The easy way to get back the old file is simply go to the File menu and look for the old filename at the bottom of the menu. "mcphc" wrote: Lets say an excel file A.xls has been opened and has had some changes made to it but not saved. Is it possible in VBA to save this file as B.xls including the changes and have file A.xls still open in excel so that if the file were to be closed you could still select to save the changes or not? Thanks Clayton |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as new file without changing existing file
Try it
Note: I use SaveCopyAs and not SaveAs -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "mcphc" wrote in message ... Unfortuantly what I want is not that simple. I basically want a macro that works just like an auto save works. So if I run the macro a file "B.xls" is saved which is a snap shot of what the file "A.xls" currently is. Then if I close file "A.xls" I am still asked if I would like to save my changes before closing. "Joel" wrote: The easy way to get back the old file is simply go to the File menu and look for the old filename at the bottom of the menu. "mcphc" wrote: Lets say an excel file A.xls has been opened and has had some changes made to it but not saved. Is it possible in VBA to save this file as B.xls including the changes and have file A.xls still open in excel so that if the file were to be closed you could still select to save the changes or not? Thanks Clayton |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as new file without changing existing file
Don't worry just found the solution
ActiveWorkbook.SaveCopyAs "C:\B.XLS" "mcphc" wrote: Unfortuantly what I want is not that simple. I basically want a macro that works just like an auto save works. So if I run the macro a file "B.xls" is saved which is a snap shot of what the file "A.xls" currently is. Then if I close file "A.xls" I am still asked if I would like to save my changes before closing. "Joel" wrote: The easy way to get back the old file is simply go to the File menu and look for the old filename at the bottom of the menu. "mcphc" wrote: Lets say an excel file A.xls has been opened and has had some changes made to it but not saved. Is it possible in VBA to save this file as B.xls including the changes and have file A.xls still open in excel so that if the file were to be closed you could still select to save the changes or not? Thanks Clayton |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save as new file without changing existing file
The easy way to get back the old file is simply go to the File menu and look
for the old filename at the bottom of the menu. "mcphc" wrote: Lets say an excel file A.xls has been opened and has had some changes made to it but not saved. Is it possible in VBA to save this file as B.xls including the changes and have file A.xls still open in excel so that if the file were to be closed you could still select to save the changes or not? Thanks Clayton |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Force Save over existing file | Excel Programming | |||
Existing file not defaulting to same location using "Save As" | Excel Discussion (Misc queries) | |||
can i save an existing .xls file as a .csv file using command line | Excel Discussion (Misc queries) | |||
get path - save new file - same sub-directory as existing file | Excel Programming | |||
Automatically replace existing file on save | Excel Programming |