diddi
Well-known Member
- Joined
- May 20, 2004
- Messages
- 3,337
- Office Version
- 2010
- Platform
- Windows
Morning all.
I have a workbook which is often updated. I have code that correctly identifies if an update has been posted to the server and notifies the user to close and get new copy. My question is: can i Shell to a .bat which will close excel, copy and replace the workbook and reopen the new version. (an auto-update). Any other options are welcome.
cheers
I have a workbook which is often updated. I have code that correctly identifies if an update has been posted to the server and notifies the user to close and get new copy. My question is: can i Shell to a .bat which will close excel, copy and replace the workbook and reopen the new version. (an auto-update). Any other options are welcome.
cheers