View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Excel 2007 VBA versus excel 2003

For the most part, code written in 2003 and earlier works fine in 2007.
There are some intentionally deprecated objects, and some small changes
which I presume are more likely unintentional. You have to test all of your
existing code against 2007, and debugging it is the same process you had to
follow in 2003. Where I have found the most issues is in charting
(understandably, since this is where 75% of my programming is done) and in
the new shape objects, whose object model thus far defies comprehension.
Most of these inconsistencies are trivial; they will nonetheless cause your
code to halt.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Mark Stephens" wrote in message
...
Hi all,

I am returning to programming after a few years I was pretty proficient in
excel 2003 and when I finished I was aware that 2003 code often didn't run
in 2007 for some trivial reasons (rounded corners didn't work I recall).
Can anyone give me an opinion on the ease with which someone who knows
2003 can transfer to 2007 is it a walk in the park or a real pain or
somewehre in between?

Kind regards, Mark