VBA code Word Templates

The company I work with uses inline forms (static .dot files) as resources
that can be added to a working template. In this context I use the
document.add command and bring these forms into the "working" template
environment. We are now merging with another company and have to make
changes to all these references. And I am not talking about the standard
references that vb programmers are used to. I am talking about places in the
VBA code that do something like this:

document.add "\\root\formdir\form1.dot"

With the merger the form1.dot (in this case) needs to be changed to some
other name. However, there are thousands of these type of references. If
the VBA code was in a text file then this would not be an issue. But as it
is now we need to open each and every .dot to find out where these references
are. What I want to know is this. Is there a way that I can find these
references "enmass" and even change form1 as a part of these search process?

aidan
Thu Aug 02 09:53:37 CDT 2007

On 2 Aug, 14:52, jaslegume <jasleg...@discussions.microsoft.com>
wrote:
> The company I work with uses inline forms (static .dot files) as resources
> that can be added to a working template. In this context I use the
> document.add command and bring these forms into the "working" template
> environment. We are now merging with another company and have to make
> changes to all these references. And I am not talking about the standard
> references that vb programmers are used to. I am talking about places in the
> VBA code that do something like this:
>
> document.add "\\root\formdir\form1.dot"
>
> With the merger the form1.dot (in this case) needs to be changed to some
> other name. However, there are thousands of these type of references. If
> the VBA code was in a text file then this would not be an issue. But as it
> is now we need to open each and every .dot to find out where these references
> are. What I want to know is this. Is there a way that I can find these
> references "enmass" and even change form1 as a part of these search process?

Been there and got the t-shirt - as a starting point, you might like
to check a program called GlobalFind ( which I think is at
http://www.kgpsoftware.com/gfind.htm ) - this would find the files you
are interested in. My own experience of find and replace has then
been that it is safer to do it manually, though I THINK you should be
able to do it in code.

jaslegume
Thu Aug 02 10:20:02 CDT 2007

Aidan:

The only problem is that this is VBA behind the template. I believe that
this global find does not see this visual basic code.

"jaslegume" wrote:

> The company I work with uses inline forms (static .dot files) as resources
> that can be added to a working template. In this context I use the
> document.add command and bring these forms into the "working" template
> environment. We are now merging with another company and have to make
> changes to all these references. And I am not talking about the standard
> references that vb programmers are used to. I am talking about places in the
> VBA code that do something like this:
>
> document.add "\\root\formdir\form1.dot"
>
> With the merger the form1.dot (in this case) needs to be changed to some
> other name. However, there are thousands of these type of references. If
> the VBA code was in a text file then this would not be an issue. But as it
> is now we need to open each and every .dot to find out where these references
> are. What I want to know is this. Is there a way that I can find these
> references "enmass" and even change form1 as a part of these search process?
>

aidan
Thu Aug 02 15:21:45 CDT 2007

On 2 Aug, 16:20, jaslegume <jasleg...@discussions.microsoft.com>
wrote:
> Aidan:
>
> The only problem is that this is VBA behind the template. I believe that
> this global find does not see this visual basic code.
>
>
>
> "jaslegume" wrote:
> > The company I work with uses inline forms (static .dot files) as resources
> > that can be added to a working template. In this context I use the
> > document.add command and bring these forms into the "working" template
> > environment. We are now merging with another company and have to make
> > changes to all these references. And I am not talking about the standard
> > references that vb programmers are used to. I am talking about places in the
> > VBA code that do something like this:
>
> > document.add "\\root\formdir\form1.dot"
>
> > With the merger the form1.dot (in this case) needs to be changed to some
> > other name. However, there are thousands of these type of references. If
> > the VBA code was in a text file then this would not be an issue. But as it
> > is now we need to open each and every .dot to find out where these references
> > are. What I want to know is this. Is there a way that I can find these
> > references "enmass" and even change form1 as a part of these search process?- Hide quoted text -
>
> - Show quoted text -

Global find WILL find the reference within the VBA (the only possible
reason it wouldn't is if the VBA is password protected)

jaslegume
Thu Aug 02 22:34:00 CDT 2007

Aidan:

Global Find does not find any code that is in a word template. I have tried
every string there is in the vba editor. I wish it did.

"aidan.heritage@virgin.net" wrote:

> On 2 Aug, 16:20, jaslegume <jasleg...@discussions.microsoft.com>
> wrote:
> > Aidan:
> >
> > The only problem is that this is VBA behind the template. I believe that
> > this global find does not see this visual basic code.
> >
> >
> >
> > "jaslegume" wrote:
> > > The company I work with uses inline forms (static .dot files) as resources
> > > that can be added to a working template. In this context I use the
> > > document.add command and bring these forms into the "working" template
> > > environment. We are now merging with another company and have to make
> > > changes to all these references. And I am not talking about the standard
> > > references that vb programmers are used to. I am talking about places in the
> > > VBA code that do something like this:
> >
> > > document.add "\\root\formdir\form1.dot"
> >
> > > With the merger the form1.dot (in this case) needs to be changed to some
> > > other name. However, there are thousands of these type of references. If
> > > the VBA code was in a text file then this would not be an issue. But as it
> > > is now we need to open each and every .dot to find out where these references
> > > are. What I want to know is this. Is there a way that I can find these
> > > references "enmass" and even change form1 as a part of these search process?- Hide quoted text -
> >
> > - Show quoted text -
>
> Global find WILL find the reference within the VBA (the only possible
> reason it wouldn't is if the VBA is password protected)
>
>

aidan
Fri Aug 03 05:24:19 CDT 2007

On 3 Aug, 04:34, jaslegume <jasleg...@discussions.microsoft.com>
wrote:
> Aidan:
>
> Global Find does not find any code that is in a word template. I have tried
> every string there is in the vba editor. I wish it did.
>
>
>
> "aidan.herit...@virgin.net" wrote:
> > On 2 Aug, 16:20, jaslegume <jasleg...@discussions.microsoft.com>
> > wrote:
> > > Aidan:
>
> > > The only problem is that this is VBA behind the template. I believe that
> > > this global find does not see this visual basic code.
>
> > > "jaslegume" wrote:
> > > > The company I work with uses inline forms (static .dot files) as resources
> > > > that can be added to a working template. In this context I use the
> > > > document.add command and bring these forms into the "working" template
> > > > environment. We are now merging with another company and have to make
> > > > changes to all these references. And I am not talking about the standard
> > > > references that vb programmers are used to. I am talking about places in the
> > > > VBA code that do something like this:
>
> > > > document.add "\\root\formdir\form1.dot"
>
> > > > With the merger the form1.dot (in this case) needs to be changed to some
> > > > other name. However, there are thousands of these type of references. If
> > > > the VBA code was in a text file then this would not be an issue. But as it
> > > > is now we need to open each and every .dot to find out where these references
> > > > are. What I want to know is this. Is there a way that I can find these
> > > > references "enmass" and even change form1 as a part of these search process?- Hide quoted text -
>
> > > - Show quoted text -
>
> > Global find WILL find the reference within the VBA (the only possible
> > reason it wouldn't is if the VBA is password protected)- Hide quoted text -
>
> - Show quoted text -

The application that I referred you to called GlobalFind DOES search
within the VBA - for example - this output searches for a routine I
use in code to automate a mainframe process - the function is called
WaitScreen which wouldn't exist outside of the VBA

--------------------------------------------------------------------------------
GlobalFind Results File. 2 result(s) found.
Search Path: t:
Search Query: waitscreen
Replace Query: (Not Specified)
Search Options: Subfolders
Error Code: (None)
--------------------------------------------------------------------------------

File (including partial path):

"TEMPLATE\Word 97 Template\Normal2.dot" Pos: 106854 Line: 178 Column:
82
"TEMPLATE\Word 97 Template\Normal2.dot" Pos: 111174 Line: 189 Column:
905
"TEMPLATE\Word 97 Template\RACC.dot" Pos: 50878 Line: 100 Column: 104

jaslegume
Fri Aug 03 07:26:01 CDT 2007

Aidan:

Once I switched the search to code that has to do with the form it found the
references. However it doesn't seem to work with modules. Anyway thank you
for all your help.

"aidan.heritage@virgin.net" wrote:

> On 3 Aug, 04:34, jaslegume <jasleg...@discussions.microsoft.com>
> wrote:
> > Aidan:
> >
> > Global Find does not find any code that is in a word template. I have tried
> > every string there is in the vba editor. I wish it did.
> >
> >
> >
> > "aidan.herit...@virgin.net" wrote:
> > > On 2 Aug, 16:20, jaslegume <jasleg...@discussions.microsoft.com>
> > > wrote:
> > > > Aidan:
> >
> > > > The only problem is that this is VBA behind the template. I believe that
> > > > this global find does not see this visual basic code.
> >
> > > > "jaslegume" wrote:
> > > > > The company I work with uses inline forms (static .dot files) as resources
> > > > > that can be added to a working template. In this context I use the
> > > > > document.add command and bring these forms into the "working" template
> > > > > environment. We are now merging with another company and have to make
> > > > > changes to all these references. And I am not talking about the standard
> > > > > references that vb programmers are used to. I am talking about places in the
> > > > > VBA code that do something like this:
> >
> > > > > document.add "\\root\formdir\form1.dot"
> >
> > > > > With the merger the form1.dot (in this case) needs to be changed to some
> > > > > other name. However, there are thousands of these type of references. If
> > > > > the VBA code was in a text file then this would not be an issue. But as it
> > > > > is now we need to open each and every .dot to find out where these references
> > > > > are. What I want to know is this. Is there a way that I can find these
> > > > > references "enmass" and even change form1 as a part of these search process?- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > Global find WILL find the reference within the VBA (the only possible
> > > reason it wouldn't is if the VBA is password protected)- Hide quoted text -
> >
> > - Show quoted text -
>
> The application that I referred you to called GlobalFind DOES search
> within the VBA - for example - this output searches for a routine I
> use in code to automate a mainframe process - the function is called
> WaitScreen which wouldn't exist outside of the VBA
>
> --------------------------------------------------------------------------------
> GlobalFind Results File. 2 result(s) found.
> Search Path: t:
> Search Query: waitscreen
> Replace Query: (Not Specified)
> Search Options: Subfolders
> Error Code: (None)
> --------------------------------------------------------------------------------
>
> File (including partial path):
>
> "TEMPLATE\Word 97 Template\Normal2.dot" Pos: 106854 Line: 178 Column:
> 82
> "TEMPLATE\Word 97 Template\Normal2.dot" Pos: 111174 Line: 189 Column:
> 905
> "TEMPLATE\Word 97 Template\RACC.dot" Pos: 50878 Line: 100 Column: 104
>
>
>
>
>

Russ
Sat Aug 04 23:09:17 CDT 2007

See the links here on how to reference and use the extensibility library.
<http://www.google.com/search?q=vba+extensibility>

Type in referenceevents in Word VBA Help for more useful info links.

After referencing the extensibility library the object browser will show
what's available in that VBIDE library.

One pseudocode logic might be to open each template with a loop and export
the .bas and form code, open the exported files in Word and do a find and
replace for needed changes, then import the new code after saving and
removing references to the old code in the VBA Editor, then save and close
the template and get the next.

> The company I work with uses inline forms (static .dot files) as resources
> that can be added to a working template. In this context I use the
> document.add command and bring these forms into the "working" template
> environment. We are now merging with another company and have to make
> changes to all these references. And I am not talking about the standard
> references that vb programmers are used to. I am talking about places in the
> VBA code that do something like this:
>
> document.add "\\root\formdir\form1.dot"
>
> With the merger the form1.dot (in this case) needs to be changed to some
> other name. However, there are thousands of these type of references. If
> the VBA code was in a text file then this would not be an issue. But as it
> is now we need to open each and every .dot to find out where these references
> are. What I want to know is this. Is there a way that I can find these
> references "enmass" and even change form1 as a part of these search process?
>

--
Russ

drsmN0SPAMikleAThotmailD0Tcom.INVALID

jaslegume
Sun Aug 05 11:02:02 CDT 2007

aidan:

I do, however, have a solution that I stubled onto. I have been using a
shareware utility for many years and I discovered that it's search function
finds all code in Word Templates.

http://www.ghisler.com/

This explore like utility is the best around and it's search function does
find VBA code


"aidan.heritage@virgin.net" wrote:

> On 3 Aug, 04:34, jaslegume <jasleg...@discussions.microsoft.com>
> wrote:
> > Aidan:
> >
> > Global Find does not find any code that is in a word template. I have tried
> > every string there is in the vba editor. I wish it did.
> >
> >
> >
> > "aidan.herit...@virgin.net" wrote:
> > > On 2 Aug, 16:20, jaslegume <jasleg...@discussions.microsoft.com>
> > > wrote:
> > > > Aidan:
> >
> > > > The only problem is that this is VBA behind the template. I believe that
> > > > this global find does not see this visual basic code.
> >
> > > > "jaslegume" wrote:
> > > > > The company I work with uses inline forms (static .dot files) as resources
> > > > > that can be added to a working template. In this context I use the
> > > > > document.add command and bring these forms into the "working" template
> > > > > environment. We are now merging with another company and have to make
> > > > > changes to all these references. And I am not talking about the standard
> > > > > references that vb programmers are used to. I am talking about places in the
> > > > > VBA code that do something like this:
> >
> > > > > document.add "\\root\formdir\form1.dot"
> >
> > > > > With the merger the form1.dot (in this case) needs to be changed to some
> > > > > other name. However, there are thousands of these type of references. If
> > > > > the VBA code was in a text file then this would not be an issue. But as it
> > > > > is now we need to open each and every .dot to find out where these references
> > > > > are. What I want to know is this. Is there a way that I can find these
> > > > > references "enmass" and even change form1 as a part of these search process?- Hide quoted text -
> >
> > > > - Show quoted text -
> >
> > > Global find WILL find the reference within the VBA (the only possible
> > > reason it wouldn't is if the VBA is password protected)- Hide quoted text -
> >
> > - Show quoted text -
>
> The application that I referred you to called GlobalFind DOES search
> within the VBA - for example - this output searches for a routine I
> use in code to automate a mainframe process - the function is called
> WaitScreen which wouldn't exist outside of the VBA
>
> --------------------------------------------------------------------------------
> GlobalFind Results File. 2 result(s) found.
> Search Path: t:
> Search Query: waitscreen
> Replace Query: (Not Specified)
> Search Options: Subfolders
> Error Code: (None)
> --------------------------------------------------------------------------------
>
> File (including partial path):
>
> "TEMPLATE\Word 97 Template\Normal2.dot" Pos: 106854 Line: 178 Column:
> 82
> "TEMPLATE\Word 97 Template\Normal2.dot" Pos: 111174 Line: 189 Column:
> 905
> "TEMPLATE\Word 97 Template\RACC.dot" Pos: 50878 Line: 100 Column: 104
>
>
>
>
>