Home > Archive > dBASE Windows API > March 2006 > Excel Print Command









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Excel Print Command
Massimiliano Ciapponi

2006-03-21, 3:32 am

I need to print an Excel Table by ole interface, because I have to convert it into a PDF file, using a postscript driver.
I tried different ways to issue the vb command :

Application.ActivePrinter = "BullZip PDF Printer su Ne03:"
ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
"BullZip PDF Printer su Ne03:", Collate:=True

but nothing happen.
Someone has a suggestion ?

Thanks.

Massimiliano Ciapponi
Rick Gearardo

2006-03-21, 3:32 am

The syntax usually needs to similiar to a function call. I have not used the
printOut function but try:

ActiveWindow.SelectedSheets.printOut(1,"BullZip PDF Printer su Ne03:",true)

Rick
"Massimiliano Ciapponi" <m.ciapponi@fastwebnet.it> wrote in message
news:4655u75SGHA.1488@news-server...
>I need to print an Excel Table by ole interface, because I have to convert
>it into a PDF file, using a postscript driver.
> I tried different ways to issue the vb command :
>
> Application.ActivePrinter = "BullZip PDF Printer su Ne03:"
> ActiveWindow.SelectedSheets.PrintOut Copies:=1, ActivePrinter:= _
> "BullZip PDF Printer su Ne03:", Collate:=True
>
> but nothing happen.
> Someone has a suggestion ?
>
> Thanks.
>
> Massimiliano Ciapponi



Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com