I have a workbook that is in the XLStart folder and loads every time excel
opens. I want to compare the version of this file on the local machine to a
copy kept on a server and replace it with the server version if it is newer.
I have the code to compare the two versions to work correctly, the problem
is updating. All macro execution stops as soon as I close the local copy to
overwrite it. I have tried putting the update code in a 3rd workbook, but
this doesn't want to work either. If I put the code in the Auto_open() or
Workbook_Open() it does not get called when I open the workbook from code.
Also, if I open the workbook and