Printing Automatically

[Mighty]

I use the following command to print an Excel chart:

xlApp.Charts(chartList(i)).PrintOut 1, 1, 1, false

However, I would like to print to a specific printer but I can't get it to work. The printer in question is on the network and the network path is \\balloonrm2\canonpix. The name of the printer on my PC is Canon PIXMA iP5000.

I have tried both of these options as the printer name with it still prints to my default print. can anyone tell me how to get around this.

Mighty

 

[PhilH123]

Mighty,

How about making this your default printer?

Phil.

 

[Mighty]

Phil,

Thanks for the suggestion. That's how I got around it but it wasn't the ideal solution as the printer is nowhere near me and I kept printing my own documents to it by accident. I actually finally got the solution. Had to use the UNC path with the full name of the printer and not the share name:

xlApp.Charts(chartList(i)).PrintOut 1, 1, 1, false, "\\balloonrm2\Canon PIXMA IP5000"

Mighty