LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Printing A Worksheet To Specific Printer Name

Hi..

I wonder if some one who could give me a bit of enlightenment.

I have 6 machines in a xp workgroup and have a document which i need to
place a print button and send page to different printers.

Each machine has had the printer drivers installed in no particular order so
the ports can be different but they are all networked using tcpip ports.. so
i cant hard code the printers in vba....

But all the names of the printers are numbered in there name all the same...
ie

01 Upstairs Printer
02 Colour Printer
03 ... etc

So I would like to do two things...

To read the list of printer and then match the printer number and send the
page to that ...
and then eventually have a print button which will load the list of printers
off the machine at runtime and give the user a way of selecting the printer
out the list..

Can ppl discuss the pro & cons and way of doing this...

Thanks

Nick


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
printing a specific worksheet everytime Trevor Excel Discussion (Misc queries) 1 May 10th 10 02:40 PM
How to disable printing a specific worksheet? Efzed Excel Worksheet Functions 1 February 21st 07 05:43 PM
How to disable printing a specific worksheet? William Horton Excel Worksheet Functions 0 February 21st 07 02:12 PM
Printing Specific data from Excel worksheet Newtonboy Excel Discussion (Misc queries) 6 July 5th 06 10:23 AM
Printing worksheet with printer tray # 3 SHA Excel Programming 10 July 25th 04 06:27 PM


All times are GMT +1. The time now is 02:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"