LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel calling WCF service K. Wilder Excel Discussion (Misc queries) 0 February 25th 10 10:52 PM
migration issue - OpenText method crashes Excel. Michael Excel Programming 0 January 9th 06 04:14 PM
Error calling Web Service from Excel Application GPrabaka Excel Programming 2 August 8th 05 03:56 PM
opentext method of excel workbook object Kislay Excel Programming 2 May 12th 05 03:56 AM
calling web service from excel 2000 Steve Richter Excel Programming 1 April 15th 05 09:43 PM


All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"