Sending a single line to the default printer

[GVF]

I am collecting data (over the course of a month) through the serial port and pasting it into Excel. The computer collecting the data is unattended. I need to send each line of data to the printer as well so I have hard copy in case something bad happens to the computer. The printer would then wait patiently for the next line of data (doesn't spit out the sheet until the sheet is full).
I ran across a snippet of code that accomplishes this, but I've lost it. I seem to recall that it involved a command used in older versions of visual basic.

Something like...
StringToPrint = "Hello" & vbCR
PRN StringToPrint

GVF

 

[HughLerwill]

Mystring = "Hello"
Printer.print Mystring

Should print Mystring to the default printer

Count the lines printed and Add a;

Printer.EndDoc

when you want a page ejected

 

[GVF]

Thanks for the help. I am coding in VBA and thought I would try this forum just in case. Didn't work.

GVF

 

[Error7]

I don't think anything will print until you send Printer.Newpage or Printer.EndDoc.

[gray]Experience is something you don't get until just after you need it.[/gray]

 

[HughLerwill]

My suggestion will not work in VBA, which does not support the Printer Object.