![]() |
|
#1
|
|||
|
|||
![]()
Thank you
This macro would be used for old documents that have the date code in them already and we don't want the date code. Instead we want to replace that code with date text. We have a lot of OLD documents with this pesky code and we want to have it change to date text when opening the document. Does this make sense? |
#2
|
|||
|
|||
![]() Quote:
Yes, this makes sense. However, the date will be the date that you run the macro, not the date that was originally in the document. See Paul's comments and macros. |
#3
|
|||
|
|||
![]()
Thank you,
It makes sense. Once the document is opened that has the date code, it is going to change before any code is run on it. I can unlink it at that time so going forward it will be text. Is there a way through a group policy or option to disable date code going forward? |
#4
|
||||
|
||||
![]()
Not really. The best you can do is use a CREATEDATE field so the date remains tied to whatever date the document is first saved, or saved via Save As. That way, whoever creates the document should at least notice that the date on a document that takes some days to complete becomes out of date.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Change font color if date in column F is prior to today's date. | kevinbradley57 | Excel Programming | 1 | 12-05-2018 07:35 PM |
![]() |
welcometocandyland | Word VBA | 4 | 02-08-2017 06:53 PM |
![]() |
cosmopolitan | Word VBA | 1 | 08-14-2013 01:58 PM |
Change format of date when using Now function in VB code | Bondai | Excel Programming | 2 | 03-02-2012 05:09 PM |
![]() |
promark | Outlook | 1 | 12-23-2005 07:21 AM |