EXCEL QUES re:PRINTER

[ssei1]

I am using xcel2000 with sp-3 and with VB6.3


I want to print directly to the printer as i do with other applications i have written in VB. Except that when i go to use PRINTER. - VBA is not recognizing PRINTER. as an object that should have properties.

The references show that I am using Visual Basic for Applications - VBE6.Dll. Is this correct? My stand-alone visual basic development environment (which understands PRINTER.) references Visual Basic for Applications MSVBVM60.DLL. I tried to change the reference in the xcel/vb, but xcel won't let me.

Is there something I have to set? Any ideas?

HELP!!!! Trying to finish this project up for a client.

Thanks in Advance.

[alex_read]

If you just want to print the sheet to the printer, you can use the Sheets("Sheet 1").PrintOut object

[ssei1]

Thanks, but what I would like to do is Print directly to the printer based on the data that I have arrayed in memory. I would like to use the Printer.Print ability of VB.

Any more ideas?

[Wooderson78]

Did you ever get this resolved? I really need to use the printer class for my VBA app. Apparently, VBA does have it... Thanks