Thread: Active printer
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marijan Glavac Marijan Glavac is offline
external usenet poster
 
Posts: 6
Default Active printer

Hi,

I have trouble with deteremine fax printer on network.
My code is :
Application.ActivePrinter ="\\server\Fax on Ne03"
Problem is that from time to time my fax printer chnage in to ="\\server\Fax
on Ne06" or ="\\server\Fax on Nexx"
Printer has been shared and the share name is "FAX"
But when I wrote :
Application.ActivePrinter ="FAX"
I got error :
Run-tem error '1004'
Method ' ActivePrinter' of object '_Appliction' failed.

Please help.

Marijan Glavač