Results 1 to 2 of 2
2015-10-06, 06:16 #1
- Join Date
- Sep 2015
- Thanked 0 Times in 0 Posts
Need a script to open a template, create a log, and create an outlook calendar reminder
I'm looking to devise an excel VBA script which will open an existing Microsoft Word Template, create a Log and finally set an Outlook reminder to review the created document in 6 months time.
This will all be triggered with a click of a button.
The Log will detail who created the document and when it was done, this would need to be in a non-editable format.
Any help would be greatly appreciated.
Thank you in advanced.
2015-10-08, 00:25 #2
- Join Date
- Jan 2001
- Melbourne, Victoria, Australia
- Thanked 264 Times in 242 Posts
Have you made any attempt at this yourself? You can do web searches for the three main components of your request and it would be good to know what you have explored so far.
Note that in order to specify the document which needs review, the new document will have to be saved first and still be there with the same name in six months time. Is this realistic?
Where should the log be stored? If it is in the same Excel workbook then I guess you will need to lock down that worksheet to make it a non-editable format.Andrew Lockton, Chrysalis Design, Melbourne Australia