Printing using VBA

S

Steven Revell

Hi,

I was wondering if it is possible to print text an error
report (currently a test string) straight to the default
printer.

If not then does anyone have any good ideas to print out
error reports?

Thanks for any help,
Steven
 
D

Dave Peterson

How about:

Option Explicit
Sub testme03()
Open "LPT1:" For Output As #1
Print #1, "An error occurred!"
Close #1
End Sub
 

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

Similar Threads

Printing Outline view - formatting lost 0
Blank Page After Envelope-Label Wizard 5
Page numbering with Merged Document and IF statements 1
Office Word JPEG in a document showing but not printing out 0
Set up and printing a 4-up mail merged postcard 0
VBA quick print function? 1
Upgraded from Win 7 to Win 10. Publisher printing black. 1
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top