Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Very slow Visual Basic code execution in new Excel 2007
Tim Williams has asked a key question: what does your code do?
I've found that Excel 2007 generally performs as fast as 2003 for most operations; sometimes a bit slower, sometimes a bit faster, but any difference was almost negligable, UNLESS I was dealing with charting/graphing or graphic objects. At that point 2007 suffers serious slowdowns. It's a known issue and MSFT is working on making it better. Example: I have an application that graphs 8800 data points in an X-Y scattercharts (51 charts in all). In Excel 2003 (on an older single core system with 1GB RAM) the whole process takes about 2.5 minutes to read the data (actually 1/2 million rows of it from a .txt file) and then create the graphs. The same process in Excel 2007 takes about 12 minutes. "JohnJohn" wrote: I have a Visual Basic procedure in the Excel of my Microsoft Office 2003 that I've run hundreds of times and it finishes in 2 minutes. Yesterday, I installed my new Microsoft Office Home & Student 2007 on the same computer (and told it to remove the old Office) and it installed with no errors or problems. But when I ran the same Visual Basic procedure that took 2 minutes to complete in my old Office 2003, now in the new Office 2007, Excel, it took 6 and a half minutes to finish (with no errors). The computer is a Toshiba laptop with 512 meg memory, 100 gig hard drive and Windows XP Professional and is only a year old. Could someone what's wrong. Why does the identical VB code take so much longer to run. Thanks ... John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
visual basic code in 2003 vs 2007 | Excel Discussion (Misc queries) | |||
Slow code execution | Excel Programming | |||
How do I hide my Visual basic code in Excel? | Excel Programming | |||
Visual Basic Code in Excel | Excel Programming |