Selecting printer from macro

B

BrianG

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!
 
K

keepITcool

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 >
 
B

BrianG

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!
 
K

keepITcool

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 >
 
B

BrianG

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!
 
K

keepITcool

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 >
 

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

Similar Threads


Top