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!!!!
|