Printer Object
 

I am using xcel2000 with VB6. I want to use the PRINTER object to send
output directly to the printer. For some reason, XCEL doesn't seem to
recognize the PRINTER object. I believe I have the right references
loaded... Any ideas?



If I do this simple program out of VB

PRINTER.PRINT "HI" 'what to print
PRINTER.ENDDOC 'send to printer
PRINTER.NEWPAGE 'eject page

I works great! It sends the word "HI" to the default printer and the
ejects the page. The minute I place the same code within the xcel/VB
environment it doesn't recognize the printer object.

ANY IDEAS?

THANKS IN ADVANCE
RICH



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Printer Object
 

VBA doesn't have a printer object.

Regards,
Tom Ogilvy

"ssei1" wrote in message
...
I am using xcel2000 with VB6. I want to use the PRINTER object to send
output directly to the printer. For some reason, XCEL doesn't seem to
recognize the PRINTER object. I believe I have the right references
loaded... Any ideas?



If I do this simple program out of VB

PRINTER.PRINT "HI" 'what to print
PRINTER.ENDDOC 'send to printer
PRINTER.NEWPAGE 'eject page

I works great! It sends the word "HI" to the default printer and the
ejects the page. The minute I place the same code within the xcel/VB
environment it doesn't recognize the printer object.

ANY IDEAS?

THANKS IN ADVANCE
RICH



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Printer Object
 

Rich

You can use VBA's text file commands to print text to a printer. See he

http://www.google.com/groups?threadm...ch% 404ax.com

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"ssei1" wrote in message
...
I am using xcel2000 with VB6. I want to use the PRINTER object to send
output directly to the printer. For some reason, XCEL doesn't seem to
recognize the PRINTER object. I believe I have the right references
loaded... Any ideas?



If I do this simple program out of VB

PRINTER.PRINT "HI" 'what to print
PRINTER.ENDDOC 'send to printer
PRINTER.NEWPAGE 'eject page

I works great! It sends the word "HI" to the default printer and the
ejects the page. The minute I place the same code within the xcel/VB
environment it doesn't recognize the printer object.

ANY IDEAS?

THANKS IN ADVANCE
RICH



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/