Is there anywhere I can view a list of the changes (if any) made to the
object model between Excel 2007 and 2010?
I have a couple of business-critical macros which I've been maintaining for
some time - when we moved from 2003 to 2007 it was quite painful since some
of the code was no longer working as it should and I had to re-write large
sections. Now we're moving to 2010 I'm hoping there's a reference I can use
to get an idea of what's changed and how much work is likely to be involved.

Thanks,
Tara

Have you looked at this?

http://msdn.microsoft.com/en-us/library/wss56bz7.aspx




"Tara H" <(E-Mail Removed)> wrote in message
news:BDC83E09-0DC1-4319-A875-(E-Mail Removed)...
> Is there anywhere I can view a list of the changes (if any) made to the
> object model between Excel 2007 and 2010?
> I have a couple of business-critical macros which I've been maintaining
> for
> some time - when we moved from 2003 to 2007 it was quite painful since
> some
> of the code was no longer working as it should and I had to re-write large
> sections. Now we're moving to 2010 I'm hoping there's a reference I can
> use
> to get an idea of what's changed and how much work is likely to be
> involved.
>
> Thanks,
> Tara

FWIW, I've found that most 2003 code that I'd painstakingly edited to
work in 2007, worked okay in 2010, except for the rare cases where 2010
had introduced some new functionality.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
774-275-0064
http://peltiertech.com/


On 5/18/2010 5:01 AM, Tara H wrote:
> Is there anywhere I can view a list of the changes (if any) made to the
> object model between Excel 2007 and 2010?
> I have a couple of business-critical macros which I've been maintaining for
> some time - when we moved from 2003 to 2007 it was quite painful since some
> of the code was no longer working as it should and I had to re-write large
> sections. Now we're moving to 2010 I'm hoping there's a reference I can use
> to get an idea of what's changed and how much work is likely to be involved.
>
> Thanks,
> Tara