I just posted a solution the other day in the NG..

(i'm no good at tinyurls.. so please search google newsgroups)

excel printing using IP address


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


BrianG wrote:

I have a form which prints using the PrintOut method. This prints to
the default printer. I have users who will change their default printer
to our plotter or inkjet printer whose limited print area affects the
form. Changing the ActivePrinter from within the macro is a problem
because the printer name is not consistent on all PC's. Is there a way,
from within the macro, to prompt the user to select the appropriate
printer?

BrianG


*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!