Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Changes
When you save a workbook that has already been saved before, Excel onl
saves the changes you have made to the workbook instead of re-savin the entire workbook to speed things up. Now, as of this moment my macro does a "saveascopy" to another serve so that people in a different department can see my workbook up to dat as it's being saved, however, my macro is being slowed waaay too fa down by this, because instead of saving the changes made to th workbook, i'm re-saving the entire workbook to those servers. Is ther anyway i can just save the changes to the workbooks if they alread exist on the other server? ..i know this may or may not be possible the code looks like this as of right now: Workbooks(Format(Date, "mmmm") & ".xls").SaveCopyAs "E:\" Format(Date, "mmmm") & ".xls" Windows(Format(Date, "mmmm") & ".xls").Close SaveChanges:=True Thanks in advance for your help : -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Changes
I think your basic assumption is incorrect. I doubt if excel only saves
changes to a workbook. The tardiness in your action is probably found in your statement my macro does a "saveascopy" to another server -- Regards, Tom Ogilvy "abxy " wrote in message ... When you save a workbook that has already been saved before, Excel only saves the changes you have made to the workbook instead of re-saving the entire workbook to speed things up. Now, as of this moment my macro does a "saveascopy" to another server so that people in a different department can see my workbook up to date as it's being saved, however, my macro is being slowed waaay too far down by this, because instead of saving the changes made to the workbook, i'm re-saving the entire workbook to those servers. Is there anyway i can just save the changes to the workbooks if they already exist on the other server? ..i know this may or may not be possible the code looks like this as of right now: Workbooks(Format(Date, "mmmm") & ".xls").SaveCopyAs "E:\" & Format(Date, "mmmm") & ".xls" Windows(Format(Date, "mmmm") & ".xls").Close SaveChanges:=True Thanks in advance for your help :) --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Saving Changes
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Automaticly saving formula's to values when saving | Excel Discussion (Misc queries) | |||
Saving Changes | Excel Discussion (Misc queries) | |||
saving to CD | Excel Discussion (Misc queries) | |||
SAVING | Excel Discussion (Misc queries) | |||
SAVING | Excel Programming |