02-18-2009 10:33 AM
Dear Readers
I wrote an application where i add and read values to/from an excel-template to create some report. I use simple activeX components (for example: Add "something" to position ("x","y") )
This works very good in MS office 2003.
When i use it with MS Office 2007, it consummes lots of my cpu (50%) and memory. The application will run maybe 20 times slower!
What is wrong? Where does the problem comes from?
Steven
02-18-2009 11:36 AM
Steven,
I also had a problem with switching from Office 2003 to Office 2007, but I was using Word. What I did as a work-around was to start Word at the beginning of the program, rather than waiting until I needed it. Is this an option for you?
-Matt
02-18-2009 02:37 PM
Yep, i read values from a database, do some calculations, open excel and place them in the template.
During the placement, cpu usage shoots till 50% and it useses +-30000K of memory. (this happens in MS Office Excel 2007 - not in 2003). The placement in 2003 takes maybe 20 secs, in 2007 2mins.
If i place the values in the template, the value is added to a graph wich has the value in his selected region.
Best regards
Steven