Specifying printer using Open For Output method?

E

Ed

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
 
B

Bob I

Not sure what this has to do with Excel spread sheets, but you can do
"NET USE LPT2 \\computername\sharedprinter\"

and then you should be able to "Open "LPT2:...............
 
E

Ed

Not sure what this has to do with Excel spread sheets, but you can do
"NET USE LPT2 \\computername\sharedprinter\"

and then you should be able to "Open "LPT2:...............





- Show quoted text -
Click to expand...

Sorry, Bob. I should have posted that in programming. It's in a
macro - I need to print out the values of an array.

Ed
 
B

Bob I

Ed said:
Sorry, Bob. I should have posted that in programming. It's in a
macro - I need to print out the values of an array.

Ed
Click to expand...

NP, you issue the NET USE LPT2 at the command prompt.
 
Top