Background information:
- I have a template created in Word 97 that has quite a few userforms and macros in it.
- The template is posted on our company's intranet.
- All employees have downloaded the template from the intranet.
- The template is changed periodically.
PROBLEM: How do we let the users know that they need to download a more current version of the template.
PROPOSAL:
What I would somehow like to do is set up some code (maybe in AutoNew module?) so that when the user opens up a new document from the template, the code will somehow call or find the template that is currently on the server for the intranet. The code would them pick something to compare (not sure what yet - any suggestions?) between the two templates to determine whether the user has the same version of the template that is available on the intranet.
If the templates match, then nothing would happen.
If the user does not have the same template as the one on the intranet, the user would then get a dialog box telling them that a new version of the corporate template is available for download on the intranet.
QUESTION:
Is this concept even possible using VBA?? I would like to get this to work, however, I have absolutely no clue where to start and I don't even know if it's possible to do.
I have been using VBA for about 9 months now and have some knowledge, but am by no means good at programming. So I need HELP!
Thanks,
Bronwyn
- I have a template created in Word 97 that has quite a few userforms and macros in it.
- The template is posted on our company's intranet.
- All employees have downloaded the template from the intranet.
- The template is changed periodically.
PROBLEM: How do we let the users know that they need to download a more current version of the template.
PROPOSAL:
What I would somehow like to do is set up some code (maybe in AutoNew module?) so that when the user opens up a new document from the template, the code will somehow call or find the template that is currently on the server for the intranet. The code would them pick something to compare (not sure what yet - any suggestions?) between the two templates to determine whether the user has the same version of the template that is available on the intranet.
If the templates match, then nothing would happen.
If the user does not have the same template as the one on the intranet, the user would then get a dialog box telling them that a new version of the corporate template is available for download on the intranet.
QUESTION:
Is this concept even possible using VBA?? I would like to get this to work, however, I have absolutely no clue where to start and I don't even know if it's possible to do.
I have been using VBA for about 9 months now and have some knowledge, but am by no means good at programming. So I need HELP!
Thanks,
Bronwyn