Macro madness

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

misscrystle@gmail.com - 03 May 2006 03:08 GMT

I have an AutoOpen macro assigned only to a specific word doc (not all
active templates etc). It changes the active printer for the document
at hand. However it also changes this printer to the default printer
for all other documents and programs. Shown below:

Sub AutoOpen()
'
' AutoOpen Macro
' Macro created 3/05/2006 by Crystle Fleper
'
ActivePrinter = "Panasonic WHOLESALE PRICELIST Printer"

End Sub

PLEASE HELP I'M GOING BANANAS!

Reply to this Message

Jezebel - 03 May 2006 09:17 GMT

In what way is the macro "assigned" to a specific document?

>I have an AutoOpen macro assigned only to a specific word doc (not all
> active templates etc). It changes the active printer for the document
[quoted text clipped - 11 lines]
>
> PLEASE HELP I'M GOING BANANAS!

Reply to this Message

Suzanne S. Barnhill - 03 May 2006 14:41 GMT

By being saved in the document rather than the template or Normal.dot?

Signature

Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

> In what way is the macro "assigned" to a specific document?
>
[quoted text clipped - 13 lines]
> >
> > PLEASE HELP I'M GOING BANANAS!

Reply to this Message

Jezebel - 04 May 2006 05:19 GMT

Possibly, but by the sounds of it the OP doesn't know enough about macros to
do that ...

> By being saved in the document rather than the template or Normal.dot?
>
[quoted text clipped - 15 lines]
>> >
>> > PLEASE HELP I'M GOING BANANAS!

Reply to this Message

Charles Kenyon - 03 May 2006 09:59 GMT

When you change the printer in Word using a macro it changes the Windows
default printer. I believe this was fixed in Word 2003 but the fix may have
been earlier. What you need to do is instead intercept the print command in
your document with a macro. Have the macro get the current printer and save
it as a string. Switch the printer and print, then change it back.

Signature

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://word.mvps.org/FAQs/ which is awesome!

My criminal defense site: http://addbalance.com
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

Reply to this Message