Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
Excel 2000 I use the following wsh script to set the default printer: Dim oNet Set oNet =WScript.CreateObject("WScript.Network") oNet.SetDefaultPrinter("hp LaserJet 1300 PCL 5e") Set oNet=nothing (The port name for that printer is DOT4_002) This works fine and the controlpanel is showing that "hp LaserJet..." is the default printer. Excel however indicates that the Application.DefaultPrinter is "unknown". When I set the default printer manually in the controlpanel Excel recognizes the default printer to be "hp LaserJet 1300 PCL 5e on Ne02:". I don't understand where Excel gets "on Ne02:" from. The portname should be DOT4_002. On some computers Excel still prints correctly to the "hp LaserJet...", however on others Excel reports an error. Any ideas? TIA po |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
setting the default printer for this workbook only | Excel Worksheet Functions | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Default printer setting | Excel Discussion (Misc queries) | |||
Printer Multiple Worksheets with a particular Printer Setting | Excel Worksheet Functions | |||
Setting Printer | Excel Programming |