Currently using xl2010:
I originally wrote this code in xl2000 by recording the print command keystrokes.
The code had been working great so far in xl2010, but I fear that yesterday my "2 BB Report" has changed Ne ports for reasons yet unknown. I wish to determine where it (and "3 Brochure") is by recording a macro.
But trying to record the keystrokes in xl2010 like I did in xl2000 only gives me:
Any suggestions on how to determine where the 2 printers reside?
Thank you
I originally wrote this code in xl2000 by recording the print command keystrokes.
Code:
Sub PrintBBReport()
'
' PrintBBReport Macro
' Macro recorded 6/30/2009 by
'
'
Application.ActivePrinter = "2 BB Report on Ne11:"
ActiveWindow.SelectedSheets.PrintOut From:=5, To:=5, Copies:=1, _
ActivePrinter:="2 BB Report on Ne11:", Collate:=True
Application.ActivePrinter = "3 Brochure on Ne10:"
End Sub
But trying to record the keystrokes in xl2010 like I did in xl2000 only gives me:
Code:
Sub Macro2()
'
' Macro2 Macro
'
'
ActiveWindow.SelectedSheets.PrintOut From:=5, To:=5, Copies:=1, Collate _
:=True, IgnorePrintAreas:=False
End Sub
Any suggestions on how to determine where the 2 printers reside?
Thank you