This project has moved and is read-only. For the latest updates, please go here.

ExcelApplication.ActivePrinter

Sep 11, 2012 at 4:34 PM

Hi,

when i display active printer with this code excelApplication.ActivePrinter, debugger diisplay "PDFCreator sur Ne00:".

But when i list printer with this code System.Drawing.Printing.PrinterSettings.InstalledPrinters the printer name is "PDFCreator" and not "PDFCreator sur Ne00:".

When i set property like this excelApplication.ActivePrinter="PDFCreator" netoffice crash because it can't find the printer .

NetOffice 1.5.1

 

Best regards

Sep 12, 2012 at 3:09 PM
Edited Sep 12, 2012 at 3:09 PM

NetOffice doesnt crash, excel throw an exception because the global printer information is not valid in excel. this is a well known propblem in all office applications (moreover access and outlook doesnt implement the ActivePrinter property) you have to use "PDFCreator sur Ne00"

Sebastian