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 VB.Net Excel 2007 Automation Performance HUGE Hit

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
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
Improve the performance of Excel 2007. Heera Excel Worksheet Functions 1 October 23rd 08 03:14 AM
How do I improve the 2007 Excel performance. Pete Excel Discussion (Misc queries) 1 April 26th 08 06:43 PM
Automation performance degradation in Excel 2007 John Austin[_6_] Excel Programming 15 January 28th 08 11:12 AM
Excel 2007 export file size huge Andy Payne Excel Discussion (Misc queries) 1 March 17th 07 11:08 PM
Excel Automation - Chart Performance Matt Tessar Excel Programming 4 August 28th 03 08:53 PM


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