Think I may have sorted this myself, In word 2010 the .activeprinter only uses the printer name and the port is left off I added the following code it does rely on excel eing install but its a work around.
Public Function GetBinNumbers2010() As Variant
'Code adapted from Microsoft KB...
Dear All,
I've been using this code snippet from MS in Office 2003, 2007 and its been working fine no issues. I've upgraded to Office 2010 and the code not working I think I've found why but can’t think of the way around it any help would be gladly received.
Line 3 sCurrentPrinter =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.