I have a workbook in the XLStart folder that loads every time excel
opens and a master copy of this file stored on a network drive. We'll call
the local copy Clientxx.xls and the master Serverxx.xls, where xx is the
version number. I want the client copy to compare itself to the master copy
and update if the master is newer.
I already have the code working to compare the versions working, but I
can't get the update code to work. I cannot update the file without closing
it, and all code execution stops once the file closes. I have tried using a
third file (update.xls) to get around the first problem, but the Auto_Open()
function never runs when the workbook is opened from code. I have also tried
calling Auto_Open() after the workbook is opened, but that code also stops as
soon as the calling workbook (Client.xls) is closed.
How can I update this file?

see my reply to your previous post

Robin Hammond
www.enhanceddatasystems.com

"AdmSteck" wrote in message
...
I have a workbook in the XLStart folder that loads every time excel
opens and a master copy of this file stored on a network drive. We'll
call
the local copy Clientxx.xls and the master Serverxx.xls, where xx is the
version number. I want the client copy to compare itself to the master
copy
and update if the master is newer.
I already have the code working to compare the versions working, but I
can't get the update code to work. I cannot update the file without
closing
it, and all code execution stops once the file closes. I have tried using
a
third file (update.xls) to get around the first problem, but the
Auto_Open()
function never runs when the workbook is opened from code. I have also
tried
calling Auto_Open() after the workbook is opened, but that code also stops
as
soon as the calling workbook (Client.xls) is closed.
How can I update this file?