View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jo Segers Jo Segers is offline
external usenet poster
 
Posts: 2
Default Problem with printing from VB-script in Excel

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.