I need a VB code to search for

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jcuster - 17 Oct 2006 17:24 GMT

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

Reply to this Message

Jonathan West - 17 Oct 2006 17:40 GMT

>I need to have a VB macro search for ".FirstPageTray = xxxxxx" and change
>it
[quoted text clipped - 4 lines]
> 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.

Signature

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

Reply to this Message

Jcuster - 17 Oct 2006 18:20 GMT

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.

> >I need to have a VB macro search for ".FirstPageTray = xxxxxx" and change
> >it
[quoted text clipped - 6 lines]
>
> Do it once, and copy the template to 200 users' desks.

Reply to this Message

Jonathan West - 17 Oct 2006 21:46 GMT

> If the user's code if different from office to office and user to user.
>
[quoted text clipped - 7 lines]
> in
> user's normal.dot.

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

Signature

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

Reply to this Message