Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
macros making files slower and slower | Excel Discussion (Misc queries) | |||
Embedded Excel macro runs 100X slower | Excel Programming | |||
String manipulation in macro runs slower each time ran. | Excel Programming | |||
Api to console application | Excel Programming | |||
Excel gets slower and slower.... | Excel Programming |