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