Auric__ pretended :
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? (Specifically Excel; I don't
usually program for the rest of the Office suite, but I program the hell out
of Excel.)

Given the support for backward compatibility that XL12 has, your XL9
projects will work just fine. My first VBA projects were XL9 and they
still work in XL12. I don't service those early projects much anymore,
but later editions have been upgraded to make use of Excel's evolving
features/functionality.

However, there's a lot of changes beyond XL9 that you'll most likely
WANT to code for so your projects can take advantage of the newer
features and functionality.

The only 'gotcha' I encountered was dictator apps no longer replacing
the menubar since it was replaced by the Ribbon. Another 'gotcha' is
that XL12+ doesn't support 'floating' toolbars and so you'll need to
rework how to handle those if your projects use them. All custom
toolbars/menus will be allocated to the Addins tab of the Ribbon. You
may want to make your own custom tabs or manipulate the Ribbon to suit
your project needs. In this case, I strongly recommend Ron De Brun's
MSO Ribbon solutions.

Best wishes in your endeavours...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc