Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to check for file update
hi -
I have a workbook 'template' (not an .xla) that will be used many users spread across the US. The current name of this file is: CashRec_v11.0_TEMPLATE.xls Occasional updates of this file will be needed, resulting in an incremental increase in the version # (ie v11.0 to v11.1 to v11.2 ....). I'd like to have a macro that runs On_Open that will check whether a newer version of the Template exists, with a pop-up box to notify ONLY if a new version exists? Thanks! Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to pull data from another file - update name of file | Excel Discussion (Misc queries) | |||
macro to check file open | Excel Programming | |||
Can you check the last update property of a file? | Excel Programming | |||
Automate open file, update links, run macro, close and save file | Excel Programming |