Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #4  
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,536
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
 

Thread Tools
Display Modes


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:20 PM.


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