joeu2004 wrote:

"Auric__" wrote:
I've acquired a copy of Office 2007. Up to now, I've
been using Office 2000. As far as VBA goes, are there
any major "gotchas" I need to be aware of? Or should
my 2000 code "just work" under 2007?

Although you seem to be interested in __program__ incompatibility, I
want to forewarn you of a __programming__ (i.e. usage)
"incompatibility".

Bottom line: Do not get rid of your copy of Excel 2000. Instead,
custom install Office 2007 so that you can retain Office 2000.

I am fortunate to have done that when I installed Office 2010 on a
system that had (still has) Office 2003.

I discovered that the F1 help information in Excel 2010 VBA is nowhere
near as good as Excel 2003 VBA. Fortunately, I still have the latter to
go back when I need help.

I don't know if the same can be said of Excel 2000 VBA v. Excel 2007
VBA. But you might be sorry if you assume otherwise.

I'll keep that in mind, but I can usually find what I want in MSDN if I can't
find it in the help files.

(Also, I'd rather not have 2 versions of *anything* installed without a
*very* good reason, and "inadequate helpfiles" aren't good enough for me.)

--
I'm not going to write that article again, because it's not true.