|
|
|
date: Mon, 22 Sep 2008 11:09:01 -0700,
group: microsoft.public.word.vba.general
back
Re: Print letters, prevent date from updating
You should be able to use the macro in
http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm to replace the DATE fields
in all documents in a single folder with CREATEDATE fields. See
http://www.gmayor.com/installing_macro.htm if you need instructions.
You'll need to make a few small changes in the macro:
- Locate the line PathToUse = "C:\Test\" and change the path in quotes to the
actual path where your documents are located. If they're in lots of different
folders, you can gather them into one folder (if they all have different names);
or run the macro multiple times, changing the path each time; or change that
line to
PathToUse = InputBox("Enter path to folder:") & "\"
so you can type in the path for each run.
- After the line Set myDoc = Documents.Open(PathToUse & myFile) add a new
line:
ActiveWindow.View.ShowFieldCodes = True
- Before the comment line that starts " 'Close the modified document " add a new
line:
ActiveWindow.View.ShowFieldCodes = False
When you run the macro and the Find dialog opens, type a space and the word DATE
(in all caps) in the Find What box. Type a space and the word CREATEDATE in the
Replace With box. Click the More button and check the option Match Case. Then
click the Replace All button.
On Mon, 22 Sep 2008 13:50:35 -0700, Angie M.
wrote:
>Hi Jay,
>
>Yes I do that, but this is a case where a client has 100's of documents that
>already have updating date fields in the documents, they need to produce them
>for a trial so they have to be printed without the date updating. Is there a
>way to tackle this? Thanks
>
>"Jay Freedman" wrote:
>
>> Angie M. wrote:
>> > Is there a way to do this? We have to produce documents for a trial,
>> > so we can't save the documents with a new date. HELP!
>> >
>> > THANKS
>>
>> Insert a CREATEDATE field in the template or document, instead of a DATE
>> field.
--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
date: Mon, 22 Sep 2008 20:57:42 -0400
author: Jay Freedman
Re: Print letters, prevent date from updating
THANK YOU JAY
"Jay Freedman" wrote:
> You should be able to use the macro in
> http://www.word.mvps.org/FAQs/MacrosVBA/BatchFR.htm to replace the DATE fields
> in all documents in a single folder with CREATEDATE fields. See
> http://www.gmayor.com/installing_macro.htm if you need instructions.
>
> You'll need to make a few small changes in the macro:
>
> - Locate the line PathToUse = "C:\Test\" and change the path in quotes to the
> actual path where your documents are located. If they're in lots of different
> folders, you can gather them into one folder (if they all have different names);
> or run the macro multiple times, changing the path each time; or change that
> line to
> PathToUse = InputBox("Enter path to folder:") & "\"
> so you can type in the path for each run.
>
> - After the line Set myDoc = Documents.Open(PathToUse & myFile) add a new
> line:
> ActiveWindow.View.ShowFieldCodes = True
>
> - Before the comment line that starts " 'Close the modified document " add a new
> line:
> ActiveWindow.View.ShowFieldCodes = False
>
> When you run the macro and the Find dialog opens, type a space and the word DATE
> (in all caps) in the Find What box. Type a space and the word CREATEDATE in the
> Replace With box. Click the More button and check the option Match Case. Then
> click the Replace All button.
>
>
> On Mon, 22 Sep 2008 13:50:35 -0700, Angie M.
> wrote:
>
> >Hi Jay,
> >
> >Yes I do that, but this is a case where a client has 100's of documents that
> >already have updating date fields in the documents, they need to produce them
> >for a trial so they have to be printed without the date updating. Is there a
> >way to tackle this? Thanks
> >
> >"Jay Freedman" wrote:
> >
> >> Angie M. wrote:
> >> > Is there a way to do this? We have to produce documents for a trial,
> >> > so we can't save the documents with a new date. HELP!
> >> >
> >> > THANKS
> >>
> >> Insert a CREATEDATE field in the template or document, instead of a DATE
> >> field.
>
>
> --
> Regards,
> Jay Freedman
> Microsoft Word MVP FAQ: http://word.mvps.org
> Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit.
>
date: Tue, 23 Sep 2008 13:56:06 -0700
author: Angie M.
|
|