I am trying to figure out how to build a macro to use Find and Replace to look for specific text and replace that text with tomorrow's date.



Look for: datez
replacement: yyyymmdd
which needs to be tomorrow's date.

Any help would be appreciated.

Thanks
tchase01

Hi tchase01,

This requires far more than a simple Find/Replace, with you can't automatically add '1' to whatever the found string is. Furthermore, your datez Find string would have to be in a specified format, which you haven't told us the details of (is it yyyymmdd?).

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

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

Hi tchase01,

You don't really need a macro to replace 'datezzz' with tommorrow's date in YYYYMMDD format. You can do that with an ordinary Find/Replace, for which you can replace 'datezzz' with any YYYYMMDD string of your choice.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]