Thread: User select printer in print macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
rocket0612[_11_] rocket0612[_11_] is offline
external usenet poster
  
Posts: 1
Default User select printer in print macro

maybe this will help, say there was a choice of 2 printers, and you have
a check box to select which printer to print from


Code:
--------------------

'deterime which printer to print from
If Range("A1") = true then myprinterselect = "\\BTBEAPAPP04\PBTBEA001M"
If Range("A2") = true then myprinterselect = "\\BTBEAPAPP04\PBTBEA002M"


Dim sCurrentPrinter As String
sCurrentPrinter = ActivePrinter
wrd.ActivePrinter = my printer select


--------------------


works for me anyway, good luck :)


--
rocket0612
------------------------------------------------------------------------
rocket0612's Profile: http://www.excelforum.com/member.php...o&userid=19492
View this thread: http://www.excelforum.com/showthread...hreadid=530690

Reply With QuoteReply With Quote