![]() |
![]() |
|
|||||||
| Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only. |
![]() |
|
|
Thread Tools | Display Modes |
|
|
#1 |
|
New Member
Join Date: Apr 2002
Location: McStevens
Posts: 3
|
I am trying to create a macro to print to a nondefault printer but I am having no success. I tried setting the ActivePrinter to the printer name and the address on the network and niether work. I made sure the names matched exactly. Any suggestions?
Peter at McStevens |
|
|
|
|
|
#2 |
|
Board Regular
Join Date: Feb 2002
Location: Stockton, California
Posts: 281
|
mcstevens,
try turning macro record on, then switch your printers and print. ive noticed that depending on the operating system, the names of printers are different. this should give you what you are looking for |
|
|
|
![]() |
| Bookmarks |
| Thread Tools | |
| Display Modes | |
|
|