1004 error [Archive] - Excel Forum

PDA

Tüm Versiyonu Göster : 1004 error


aoc
08-04-2007, 00:09
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 ?

Ivan F Moala
28-05-2007, 10:36
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:


Özel Arama