Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I originally wrote an app that I'm still testing on a XP PC with 2GB Ram and
1 CPU. Took 7 minutes to create 1 file. I'm creating over 100 files so this is not a good sign. I move app to a XP PC with 3GB and 2 CPUs. App now created sames files in just under 1 minute each. Another week or so goes by, I'm just adding a few features and fixing formatting and data sourcing issues, and suddently last 3 days, same 2 CPU PC, files take 7-9 minutes each. I cannot account for this. Any suggestions? Additionally, I'm getting totally random 0x800A03EC errors, mostly on Excel WS PAST methods. I do Source Activate, Select, Copy, Target Select, Paste in a lot of places. It wil randomly (seemingly) abend on the Paste. If I run in debug mode and ut a break on all Catch blocks once it gets tripped, I determine hich line had the issue (always on a Paste), I look for the Soure Activate statement that prceded the Target Paste and set that instruction to be next statement, and press GO. Runs fine. Might break again different place, same file, or break 10-30 files later. Always restartable. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Improve the performance of Excel 2007. | Excel Worksheet Functions | |||
How do I improve the 2007 Excel performance. | Excel Discussion (Misc queries) | |||
Automation performance degradation in Excel 2007 | Excel Programming | |||
Excel 2007 export file size huge | Excel Discussion (Misc queries) | |||
Excel Automation - Chart Performance | Excel Programming |