VB.NET Print Excel Sheet to Specific IP / Network Printer Name

STP_CAPTAIN_CLOW

New Member
Joined
Aug 27, 2014
Messages
1
Hi All

I have been looking for a long time for a solution for what I thought would be a simple issue.....

In my program I am opening an Excel template via Interop populating the required information and then trying to send the file to print to a specific printer. After being unable to find a way to send the file using an IP Address I simply entered the Printer Name and while in Debug it worked fine.

As soon as I published the program and installed it on the client computers the file would always print to the default printer on the client machine, I have made sure the printer is installed on the client machine and is named the exact same.

This is the code I am using to point to the printer and while in debug is works perfect:

Code:
xlWorkSheet.PrintOutEx(ActivePrinter:="HP Colour LJ2605 - Packing Station")
Any advice on why this code isn't working when published and installed on the client machines would be much appreciated or any alternative code that I could try as this is driving me insane, especially as it works in debug.

Many Thanks
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,101,914
Messages
5,483,689
Members
407,399
Latest member
Rakeforms

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top