ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Excel Printing Service (https://www.excelbanter.com/excel-programming/276786-excel-printing-service.html)

Alejandro Calbazana

Excel Printing Service
 
Hello,

I have been searching for a decent way of running an NT service that
invokes an instance of Excel in order to print excel worksheets to PDF
through code.

In my current setup, I use Adobe PDF Writer as the PDF driver and have
a written an NT service to poll a data store for queued documents.
All works reasonably well when run as a standalone application,
however, when I attempt to place this in a service context, the Excel
process hangs and nothing is printed.

I have allocated the service to run under the local_sys account and
have also added printers to the default user per knowledge base
articles on the subject. However, I haven't found this to be
bulletproof.

I understand that office automation in a service is not very well
supported, but I also know that this is a common task. Printing
office artifacts to PDF should be a common request since both are
somewhat ubiquitous. Running an open login session is not really an
option.

Any help is appreciated.

Thanks,

Alejandro

Jim Rech

Excel Printing Service
 
I guess you've seen this article:

http://support.microsoft.com/default.aspx?scid=kb;[LN];257757

"Microsoft does not recommend or support server-side Automation of Office."



--
Jim Rech
Excel MVP




All times are GMT +1. The time now is 10:00 AM.

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