Problem with printing from VB-script in Excel

J

Jo Segers

Hi,

I have a problem when I try to print an Excell sheet from VBscript.

Chart9.PrintOut Copies:=1, ActivePrinter:= "\\pc0020\hp deskjet 6122
series op Ne01:", Collate:=True


The problem is:
ActivePrinter:= "\\pc0020\hp deskjet 6122 series op Ne01:"

Why does is add "op Ne01:" and where does it get this information?

The script works on my pc, but on an other pc I have to change "op
Ne01:" to "op Ne05:"

Where can I find this information?

Mvg,

Jo Segers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Printing Macro 1
Automated Printing 2
Setting ActivePrinter in Excel 3
Excel does not close from VB!! (when i refresh Refresh query with BackgroundQuery:=False) 1
problem with printing in a small win xp home network 2
SOLVED: Network Printing with HP PSC 1350 6
Printing with Visual Basic Editor Problem 3
Problem with format when printing to Word from Access 2

Top