Footer Dates

[Steve C]

We have several dozen documents in one folder (G:\Specs)where the same footer
information was inserted on each page. Among that information is a date
(manually typed -- it is not a Date field), which is the same for each
document in that folder.

What we want to do is if the footer date in all of these documents needs to
be changed, run a macro that opens each document, seeks out the date in the
footer and replaces it with whatever date we want (provided by perhaps an
Input Box). The format of the date is typically 09-21-05, but also may be
09/21/05. Can anyone give me some ideas? Thanks!

 

[Graham Mayor]

See http://www.gmayor.com/batch_replace.htm

Modify the code to use a wildcard search for
[0-9]{2}[//-][0-9]{2}[//-][0-9]{2}

and replace with your new date

You may, depending on what else is in the document, need to limit the story
ranges to the footers.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Steve C]

Graham,

Thanks a ton for the code! I will give it a try.

See http://www.gmayor.com/batch_replace.htm

Modify the code to use a wildcard search for
[0-9]{2}[//-][0-9]{2}[//-][0-9]{2}

and replace with your new date

You may, depending on what else is in the document, need to limit the story
ranges to the footers.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

We have several dozen documents in one folder (G:\Specs)where the
same footer information was inserted on each page. Among that
information is a date (manually typed -- it is not a Date field),
which is the same for each document in that folder.

What we want to do is if the footer date in all of these documents
needs to be changed, run a macro that opens each document, seeks out
the date in the footer and replaces it with whatever date we want
(provided by perhaps an Input Box). The format of the date is
typically 09-21-05, but also may be 09/21/05. Can anyone give me
some ideas? Thanks!