Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel runs much slower in console app

Hi,

I've got an app that can either run with a GUI or in a console. The
app retrieves a report from Reporting Services and then merges it with
a Excel template. The code that processes the reports it's exactly
the same, whether you run with GUI or without. The problem is the
Excel automation code runs about 10 times slower in console mode. For
instance, the Workbook.SaveAs() method takes about a minute in console
mode and a few seconds in GUI mode. Again, the only difference
between the two modes is one shows a form the other displays a
console.

Any ideas would be much appreciated.

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Excel runs much slower in console app

Ok, just after I made the original post, I figured the problem out. I
needed to add Application.Run() (with no parameters), and then call
Application.Exit() when the reports finished processing. Must have
something to do with starting a message pump for the process.

Thanks
Reply
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
macros making files slower and slower Raja Excel Discussion (Misc queries) 1 May 9th 08 12:26 AM
Embedded Excel macro runs 100X slower JS[_7_] Excel Programming 5 March 24th 06 11:14 PM
String manipulation in macro runs slower each time ran. Lamination Technology Excel Programming 6 March 16th 06 05:57 AM
Api to console application Jean-Yves[_2_] Excel Programming 4 August 17th 05 02:19 PM
Excel gets slower and slower.... Romuald[_3_] Excel Programming 3 July 7th 05 02:25 PM


All times are GMT +1. The time now is 11:36 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"