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

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/

Saving Changes
 

i think you're right..

--
Message posted from http://www.ExcelForum.com