ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do I print to a printer in VB 6? (https://www.excelbanter.com/excel-programming/428956-how-do-i-print-printer-vbulletin-6-a.html)

bnadler

How do I print to a printer in VB 6?
 
I am just learning VB6 and I do not see how data is sent to a printer. There
is not a printer method that I can find

joel

How do I print to a printer in VB 6?
 
Try PRINTOUT

activesheet.printout

"bnadler" wrote:

I am just learning VB6 and I do not see how data is sent to a printer. There
is not a printer method that I can find


bnadler

How do I print to a printer in VB 6?
 
I have tried using Printer.Print but I cannot find the Printer object
anywhere. It isn't even listed in the help section.

"Joel" wrote:

Try PRINTOUT

activesheet.printout

"bnadler" wrote:

I am just learning VB6 and I do not see how data is sent to a printer. There
is not a printer method that I can find


joel

How do I print to a printer in VB 6?
 
Microsfot documentation is really bad. they don't tell you what type object
you are suppose top use. In this case the object is the worksheet and you
can't change printers. The printer is the default printer on you PC.

activesheet.printout

"bnadler" wrote:

I have tried using Printer.Print but I cannot find the Printer object
anywhere. It isn't even listed in the help section.

"Joel" wrote:

Try PRINTOUT

activesheet.printout

"bnadler" wrote:

I am just learning VB6 and I do not see how data is sent to a printer. There
is not a printer method that I can find


Dave Peterson

How do I print to a printer in VB 6?
 
You may want to ask in a forum dedicated to VB--not excel.

If you really meant you wanted to print something in excel's vba:

worksheets("Sheet999").printout 'preview:=true
or
worksheets("sheet999").range("x1:Z9").printout 'preview:=true

bnadler wrote:

I am just learning VB6 and I do not see how data is sent to a printer. There
is not a printer method that I can find


--

Dave Peterson


All times are GMT +1. The time now is 12:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com