I need a VB code to search for

J

Jcuster

I need to have a VB macro search for ".FirstPageTray = xxxxxx" and change it
to ".FirstPageTray = 16642" inside the code. I also need to do the same thing
with ".OtherPagesTray = xxxxxx"

I do not want to do this by hand because I would have to visit over 200
user's desks
 
J

Jonathan West

Jcuster said:
I need to have a VB macro search for ".FirstPageTray = xxxxxx" and change
it
to ".FirstPageTray = 16642" inside the code. I also need to do the same
thing
with ".OtherPagesTray = xxxxxx"

I do not want to do this by hand because I would have to visit over 200
user's desks

Do it once, and copy the template to 200 users' desks.


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 
J

Jcuster

If the user's code if different from office to office and user to user.

That brings me to another question, If I want to create a standard
letterhead macro. How can I get the none savvy user to import it and kill
the old letterhead macro. Thats what I really want to do without walking all
over the place.

I do not want to distribute new normal.dots because of the custom coding in
user's normal.dot.
 
J

Jonathan West

Jcuster said:
If the user's code if different from office to office and user to user.

That brings me to another question, If I want to create a standard
letterhead macro. How can I get the none savvy user to import it and kill
the old letterhead macro. Thats what I really want to do without walking
all
over the place.

I do not want to distribute new normal.dots because of the custom coding
in
user's normal.dot.

Distributing macros to other users
http://www.word.mvps.org/FAQs/MacrosVBA/DistributeMacros.htm


--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top