Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.programming,microsoft.public.excel.programming
|
|||
|
|||
Add footer automatically
Let me start by saying that I am new to programming VBA Macros, but I'm
learning on the fly and I'll be happy to try out any and all suggestions. Now, on to the problem. We're trying to come up with a way of having a unique id number for every new document created. I think that a good way to do this is to create templates for word and excel (the two programs we use for document creation). I'm trying to come up with a macro for the templates that automatically adds a footer with a trimmed down time/date stamp upon the first save. By "trimmed down" I mean that 12/04/2006 11:15:32PM would be shortened to 12042006111532. I only need it to do this the first time a document is saved because if the time/date updated itself every time the document was used it would undermine the whole plan for unique document id numbers. Thanks for your help. Brett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to ALWAYS have footer automatically? | Excel Worksheet Functions | |||
automatically insert footer | Excel Discussion (Misc queries) | |||
Can you set up Excel to automatically add a standard footer? | Excel Discussion (Misc queries) | |||
can excel automatically insert a custom footer in all files | Excel Discussion (Misc queries) | |||
Filename in footer automatically in new workbook. | Excel Discussion (Misc queries) |