Posted to microsoft.public.excel.programming

ricowyder

external usenet poster

Posts: 21

Choose Printer other than default

Thanks for all of your previous help.

I have a short question. Wrote this sub and it's working fine. Though,
it's using default printer. Any chance that I can offer a list of
installed printers to choose from? Thanks for your answer.

Regards,

Rico

Sub PrintSheets()

ThisWorkbook.Worksheets("Name01").PrintOut Copies:=1, Collate:=True
ThisWorkbook.Worksheets("Name02").PrintOut Copies:=1, Collate:=True

End Sub

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
members on my network printer not able to print to default printer	smeheut	Excel Discussion (Misc queries)	0	June 18th 07 06:42 PM
Default Printer	carlito_1985	Excel Programming	1	June 27th 05 08:27 AM
Choose a printer	Alvin Hansen[_2_]	Excel Programming	4	March 13th 05 01:32 PM
Help with macro to choose printer	Wind54Surfer	New Users to Excel	2	December 21st 04 12:09 AM
default printer	solo_razor[_21_]	Excel Programming	1	October 30th 03 03:22 PM

All times are GMT +1. The time now is 11:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us