Thread: [Solved] Macro for tomorrow's Date
View Single Post
 
Old 03-01-2012, 06:41 AM
tchase01 tchase01 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Feb 2012
Posts: 2
tchase01 is on a distinguished road
Default Macro for tomorrow's Date

Here is an example of what I am trying to do below, search for the 'datezzz' and replace it with the following days date '20120302'. I have many articles in one file that i need to make this change to. I am using Word 2007. The datezzz format is just text, but I need it to be a date in text format 'yyyymmdd' as in the examples below:

Original

<article>
<filename>article.xml</filename>
<timestamp>04:00:27</timestamp>
<pubdate>datezzz</pubdate>
<section>Business</section>
<taxonomy>13</taxonomy>
<keyword></keyword>


Replacement

<article>
<filename>article.xml</filename>
<timestamp>04:00:27</timestamp>
<pubdate>20120302</pubdate>
<section>Business</section>
<taxonomy>13</taxonomy>
<keyword></keyword>


Thanks for looking and trying to help!!!!
Reply With Quote