Trying to print using VB 6.3 in Excel.

Despite the claims of common googled results, the following simple code does not work:

Printer.FontItalic = True
Printer.Print "test message"
Printer.EndDoc

I get an object required error. Anyone know how to do this?

11/12/2007 1:54:51 PM

The "Printer" object doesn't exist in VBA. That's VB only. Create a document (Word, Excel, or other) using VBA and print it using the handling application (this can be called through VBA -- I'd figure it out for you, but my Office 2k3 installation is a little fucked right now and VBA isn't working)

[Edited on November 12, 2007 at 3:24 PM. Reason : ]

11/12/2007 3:22:12 PM

Thanks. Will do.

11/12/2007 4:48:16 PM