BorlandTalk.com

Lee-Z · Guest

D4, Excel2000 (clients on Win2000)

I have a report that eventually will have to printed in PDF (for which we
have a useful PDF-writer tool....not Acrobat ;o) ). At the moment the report
is constructed in Excel (because there are some complex formula's in it and
because I seriously dislike Quickreports) and my application fills the excel
sheet and sends the workbook to the pdf-writer-printer.

My question is: how do I select the right printer so Excel will know where
to print to?

If I would send a quickreport to a specific printer I'd use
qrep.printersettings.PrinterIndex := printer.printers.Indexof("PDFWriter")

If I use the Excel GUI and select the printer manually "PDFWriter" is in the
list of available printers....but if I use an Excel-macro it wants
"PDFWriter on Ne00:" (or something like that....on dutch Windi it would be
"...op Ne00:")

How do I tell Delphi to use "PDFWriter on Ne00:" instead of "PDFWriter"? Or
is there a way to print from excel using printerindex? Or should I use
quickreport instead (and use it's printerIndex property)?

Thanks for your help....

Lee-Z