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: 108
Default 2003 and 2007

Hello, a bit of a strange question.
I have a vba program, which reads data from one sheet and writes to another
sheet.

Performance tests have shown,
7 - 11 minutes in Excel 2003
2 -3 minutes in Excel 2007
Same data, same code.

Did 2007 have huge performance gains?
Is there anything i can set in 2003 to get additional performance? Such as
shutting off calculation? Printer settings?
Something else?

thanks


 
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
Excel opens two windows (2007 & 2003 format): I want only 2003. Rob Excel Discussion (Misc queries) 0 March 6th 10 07:46 PM
Saving from 2007 to 2003 - 2003 won't open the file James Piper Excel Discussion (Misc queries) 0 February 2nd 10 02:56 PM
2003-2007 xlsm-2003 loses worksheet commandbutton functionality ker_01 Excel Programming 1 May 5th 09 02:11 PM
2003--2007 recognize if i'm in 2007 or 2003 via code. Miri Excel Programming 3 October 15th 08 02:50 PM
Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros andcons please Simon[_2_] Excel Programming 3 August 5th 08 03:48 PM


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