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!

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!

Printing to an IP address won't help. Our LAN is Netware 4.11 using IPX
protocol only. Printers are ported to Netware print queues.

BrianG



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

Brian,

did you even bother to READ the thread?


the thread happened to be related to IP printer...
the CODE was and IS generic but untested for IP.

Afaik (and can test) the code supports all versions of excel,
on all (windows) platforms in ALL excel language versions.
It does work on local printers and should work on network printers, though
I cant test for Netware queues.


At least give a a try.
Then please let me know it works or doesn't


keepITcool

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


BrianG wrote:

Printing to an IP address won't help. Our LAN is Netware 4.11 using IPX
protocol only. Printers are ported to Netware print queues.

BrianG



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

Sorry keepITCool. Your response is very much appreciated and I did look
at it. It is just so waaaaay over my head that I didn't understand it
and since the topic was "printing to an IP printer", well I just
assumed....

I'm a real beginner at this. My experience with VB is limited to
automating some forms using Excel97 macros. I discovered early on that
including code that I didn't understand only caused me problems later.
I have no doubt my code would be considered a disaster by someone of
your skill. So, if I can't find a solution to printer selection that I
can feel comfortable including in my code I'll just live without it, and
remind users to check their default printer before printing my forms.
Hey, they're not willing to put in the effort to figure out how to
create their own automated forms so it's either mine or nothing<g.

Thanks again for the response.

BrianG



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

copy my code to a standard module..

then run de macro Demo.
if you see a new workbook with a list of printers..
hey! it works.


then create a userform.
add a combobox

then add code:
Private sub Userform_initialize()
combobox1.list = Printerlist()
end sub


that's all there's to it. really.





keepITcool

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


BrianG wrote:

Sorry keepITCool. Your response is very much appreciated and I did
look
at it. It is just so waaaaay over my head that I didn't understand it
and since the topic was "printing to an IP printer", well I just
assumed....

I'm a real beginner at this. My experience with VB is limited to
automating some forms using Excel97 macros. I discovered early on
that
including code that I didn't understand only caused me problems later.
I have no doubt my code would be considered a disaster by someone of
your skill. So, if I can't find a solution to printer selection that
I
can feel comfortable including in my code I'll just live without it,
and
remind users to check their default printer before printing my forms.
Hey, they're not willing to put in the effort to figure out how to
create their own automated forms so it's either mine or nothing<g.

Thanks again for the response.

BrianG



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