View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Salar Madadi Salar Madadi is offline
external usenet poster
 
Posts: 1
Default Calling Excel/Opentext method via ActiveX in a service application

Hello,

We have a service application that acts as a scheduled report generator. It
reads a schedule from a database and then runs various reports, emailing the
results in PDF / EXCEL format. We use a CSV file of the report and export
it to excel using the opentext method. Everything works perfectly with the
exception of the Excel export. If we setup a report to only export to PDF,
the report will run perfectly and multiple runs of the report will take
approximately the same amount of time. If we setup a report to use the
Excel export, the first run of the report could take 20 seconds, then the
second run, 1 minutes, the next run 5 minutes and so on until the service
slows down to a crawl. This is fixed as soon as the service is restarted.

Is anyone aware of any issue with using calling Excel / Opentext method
using activeX through a service application? Any idea what could be causing
this slowdown?

--

Regards,

Salar Madadi
- Latest Developments Inc.