Printing to a network printer using Excel in VB.Net

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dawn

    Printing to a network printer using Excel in VB.Net

    My application is coded to create a report using Excel and I would like to
    send it directly to a pre-determined network printer.
    (My intention is to pass the printer name in a variable.)
    However, there is a suffix that is added to the printer name and the printer
    suffix is not consistent ......
    "on Ne00" on my pc
    "on Ne01" on another pc
    Is there a way to consistently code the printer name ?

    mxlApp.ActivePr inter = "Dell Laser Printer M5200" '
    actual network printer name - but gives an error.
    mxlApp.ActivePr inter = "Dell Laser Printer M5200 on Ne00:" 'name
    VB.net code recognizes..but not consistent between pc's on network

    Thank you
    Dawn
    (newbie)


Working...