Hi guys, both your responses have me doing some more thinking, so I would like to thank you for this, I appreciate the time that you have given towards providing a solution.
I guess as usual everything is about the logic being followed, which is not always that clear, and the timing as to when the logic is applied.
Once the Word template has been opened, there is data which is written to the template via the Excel file and some data which is written in by the user. One of the items is the next serial number for the document. The file name becomes serial number + name of user + event name + date created (dd.mm.yyyy).
There is also a hyperlink created to the saved document anchored to the serial number.
I guess to this another approach is simply to force the serial number and not to allow any modifications.
Thanks to you guys I now have some options to think about and pursue.
Best Wishes
Megazoid
|