-
1004 error
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 ?
-
Err 1004 means the printer you specified doesn't exist. Try a one line macro
debug.print application.activeprinter after you manually set your printer of
choice to get the exact printer name.
-
Try Application.ActivePrinter = "?zerindeki HP DeskJet 840C/841C/842C/843C on Ne02:"
Have a look at this KB Item
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules