Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi, Tom. Thanks much - I will give this a try.
Ed On May 3, 10:56 am, Tom Ogilvy wrote: Substitute the network name for LPT1 as an example, this worked for me in the past: Sub Macro5() Dim ctrl As Long Dim tmpstr As String Open "\\ARDAPS01\1D343E" For Output As #1 Print #1, "[Start of Printing Test]" For ctrl = 1 To 10 tmpstr = "Printing Line " + Str(ctrl) Print #1, tmpstr Next tmpstr = "[End of printing test]" + Chr(12) Print #1, tmpstr Close #1 End Sub -- Regards, Tom Ogilvy "Ed" wrote: My apologies for double-posting - I inadvertently put this in the general Excel group first. Right now I have Open "LPT1:" For Output As #1 But I can't use my LPT1 printer at the moment. Is there a way I can specify a networked printer? Ed- Hide quoted text - - Show quoted text - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Forcing Same Output Regardless of Printer | Setting up and Configuration of Excel | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
How do I send a spreadsheet to a printer outside the network? | Excel Discussion (Misc queries) | |||
Selecting a Printer on a network | Excel Programming | |||
selecting network printer | Excel Programming |