Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-15-2020, 10:31 AM
Legal Learning Center Legal Learning Center is offline AutoOpen code to change date code to date text Windows 10 AutoOpen code to change date code to date text Office 2016
Novice
AutoOpen code to change date code to date text
 
Join Date: Feb 2020
Location: Boulder, Colorado
Posts: 3
Legal Learning Center is on a distinguished road
Default

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?
Reply With Quote
  #2  
Old 02-15-2020, 06:46 PM
Charles Kenyon Charles Kenyon is offline AutoOpen code to change date code to date text Windows 10 AutoOpen code to change date code to date text Office 2019
Moderator
 
Join Date: Mar 2012
Location: Sun Prairie, Wisconsin
Posts: 9,464
Charles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant futureCharles Kenyon has a brilliant future
Default

Quote:
Originally Posted by Legal Learning Center View Post
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?

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.
Reply With Quote
  #3  
Old 02-22-2020, 01:35 PM
Legal Learning Center Legal Learning Center is offline AutoOpen code to change date code to date text Windows 10 AutoOpen code to change date code to date text Office 2016
Novice
AutoOpen code to change date code to date text
 
Join Date: Feb 2020
Location: Boulder, Colorado
Posts: 3
Legal Learning Center is on a distinguished road
Default

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?
Reply With Quote
  #4  
Old 02-22-2020, 02:24 PM
macropod's Avatar
macropod macropod is offline AutoOpen code to change date code to date text Windows 7 64bit AutoOpen code to change date code to date text Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,363
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Legal Learning Center View Post
Is there a way through a group policy or option to disable date code going forward?
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]
Reply With Quote
Reply



Similar Threads
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
AutoOpen code to change date code to date text VBA Code to search for field codes with certain text before the Field code and to change style welcometocandyland Word VBA 4 02-08-2017 06:53 PM
AutoOpen code to change date code to date text VBA code for inserting a future date 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
AutoOpen code to change date code to date text Imported message date change to today's date promark Outlook 1 12-23-2005 07:21 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:55 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft