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?