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 -

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

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

Top