Specifying printer using Open For Output method?

  • Thread starter Thread starter Ed
  • Start date Start date
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
 
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:...............
 
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
 
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.
 
Back
Top