All geek questions in one place

VBA in new versions of Excel

That is the question for my Father. It has been using VBA in Excel for over two decades, from Excel 5 to the present, when it uses Excel 2002.

Since he had been using VBA in Excel for so long, making extensive use of the ability to record macros , he continued to invest in Excel because it was pretty stable (in terms of its VBA functionality) in each version. Now he is considering switching to a newer version of Excel, but I read reviews that Microsoft completely ruined its VBA interpreter in Excel 2007, because scripts that previously worked in Excel 2003 or earlier would become painfully slow or stop functioning altogether. Then, looking in Excel 2010, I read that many problems with Excel 2007 are “not fixed”. Since I'm not sure about the veracity of these reviews that I read, I ask this question. For all those people who are currently actively using VBA in Excel:

Would it be worthwhile for someone who has a lot of time and work to invest in VBA from Excel 2002 or earlier to upgrade to Excel 2003, 2007 or 2010?

+3
source share
3 answers

There are several performance issues in Excel 2007 VBA. Many of them were fixed in Excel 2007 SP1. There were also problems with macro recorders with charts and figures.

My personal recommendation is Excel 2010: VBA performance problems and macro recorder problems have been fixed, and I believe that the overall stability of Excel 2010 is superior to the latest versions (but YMMV).

Excel 2002 2007 2010 : , , , , Excel. , VBA .

+5

Excel 97, 2007 2010 . , . , 97 2003 .

, Excel 2007 VBA.

+2

VBA/Excel, Excel 2003, 2007 (, , ). , , VBA Excel 2007 . , , ( , , , , , ).

, UBitMenu , .

Excel VBA, 6 . , 373 , , Excel 2007 . Excel 2003, 2007, 2003, 2002, Excel 2010 , Excel 2003. 2010 2003 , , Excel 2003 , 2010 VBA. http://exceltrader.net/et2/benchMark.php.

0

Source: https://habr.com/ru/post/1767273/

More articles:


All Articles