Martin Brown wrote:

On 13/12/2011 02:20, 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? (Specifically
Excel; I don't usually program for the rest of the Office suite, but I
program the hell out of Excel.)

A longish list but they are mostly pretty obscure features that you may
not actually use. Certain dialogues for file find withdrawn etc.

Main ones that forced me to fork the code are gratuitous changes to
graphics objects coordinates and colours together with a bunch of
interesting race conditions if you ever draw large numbers of graphs
from VBA. Basically stuff that works fine before XL2007 is broken in the
later versions and for good measure some of the improvements in XL2010
put it back to how it was before. There are work arounds for all of it.
XL2007 can be glacially slow for larger datasets and now has to display
an estimated time to completion to stop users thinking it has crashed.
The same operations on XL2003 took under 5 seconds.

It is better now after the SPs than it was out of the box originally.

....interesting.

Defaults for charts are awful in XL2007 unless you like the drawn by a
kid with a wax crayon look for your business graphs. And to add insult
to injury customising charts makes them *even* slower to draw.

Fortunately, I only have 2 spreadsheets with any kind of charts, and those
are both just simple line graphs. Actually... I use one of them to estimate
future needs. I'll have to see if that's changed any.

The macro recorder in XL2007 is wrecked and completely FUBAR.

Luckily, I rarely need it.

I expect others will chime in with more examples of gotchas.

Why move to 2007 at this stage when XL2010 is out?

Money. I don't spend my own on office software; I use what I have until
someone else pays for a new version for me. Usually it's work, but this time
my sister-in-law got 2010 for herself, so I got her copy of 2007.

--
You never keep any of your promises.