Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how can I use print preview without having a printer | Excel Discussion (Misc queries) | |||
members on my network printer not able to print to default printer | Excel Discussion (Misc queries) | |||
Printer.Print Not Working? | Excel Programming | |||
how can I get my printer to print in grayscale ? | Excel Discussion (Misc queries) | |||
Code to Print to certain Printer | Excel Programming |