1004 error

aoc

Katılım
23 Ekim 2005
Mesajlar
13
Excel Vers. ve Dili
excel 2003 Türkçe
hi,

when I run the code below I get

1004 error " Method 'ActivePrinter' of object '_Application' failed "

üzerindeki is the turkish of on

Sub ece()
Application.ActivePrinter = "Ne02: üzerindeki HP DeskJet 840C/841C/842C/843C "
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

what is the problem ?
 
Katılım
21 Ağustos 2004
Mesajlar
12
Excel Vers. ve Dili
Xl2000, 2003, 2007
hi,

when I run the code below I get

1004 error " Method 'ActivePrinter' of object '_Application' failed "

üzerindeki is the turkish of on

Sub ece()
Application.ActivePrinter = "Ne02: üzerindeki HP DeskJet 840C/841C/842C/843C "
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End Sub

what is the problem ?
You printer set is probably wrong
Ne02: may be the culprit.

The Network port is different for each computer i.e it may be
Ne03: for different computers on the network.

Yo may need to loop through each iteration of Ne00: to Ne16:
 
Üst