Gord Dibben wrote:

On Wed, 14 Dec 2011 14:39:19 -0800, "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.

At a minimum find and save all the 2000 version VBA???.chm files.

You can d-click to open them when you really need help.

Is there *that* little info in the 2007 helpfiles to warrant it?

Or...........if brave enough...............rename the 2007 *.chm files

Back them up first.

I've got 2000 on my server's Windows install; I can copy them over if-and-
when.

--
Many can understand.
What people do with understanding is another matter.