ExcelBanter - Printing using VBA

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Printing using VBA (https://www.excelbanter.com/excel-programming/277965-printing-using-vba.html)

Steven Revell

Printing using VBA

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

Dave Peterson[_3_]

Printing using VBA

How about:

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

Steven Revell wrote:

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

--

Dave Peterson

All times are GMT +1. The time now is 11:56 PM.