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 -

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top