Excel VBA Syntax Code Problem. ExecuteExcel4Macro, pass printer variable.

Sub PrintToYellow() ' ' PrintToYellow Macro ' ' Dim sCurrentPrinter sCurrentPrinter = Application.ActivePrinter Dim sNewPrinter sNewPrinter = "production-win on DC1" MsgBox ("Printer passed to function = " & sNewPrinter) 'call function to return actual co

www.experts-exchange.com