| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Updating hiden workbook
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hiden cells copied automatically to another workbook, can I stop . | Excel Worksheet Functions | |||
| My workbook links are not updating (its 30,000 KB size workbook). | Excel Discussion (Misc queries) | |||
| Auto updating a workbook with data from another workbook | Excel Discussion (Misc queries) | |||
| Excel Workbook hiden when written to from Word | Excel Programming | |||
| Transparently updating another workbook from the current workbook | Excel Programming | |||
Threaded Mode
