VBA in Office 2010 - Changes

VBA projects you have previously done are still usable in Office 2010 (at least on x86) although you will need several changes. Since VBA never has reasonable error messages to tell you the error source, I'll tell you before you pull out your precious hair:

Format() for Date objects will not work now, and as usual your editor will not give you any reasonable error message. So here is how MS wants it now: VBA.Format()
Same thing for Now().
Although you can not use Now() in VBA or com/activex object properties. Time() is the way to go.

Will tell more as I come through.
BTW, just start using VSTA in future projects.
Here is a quote from Dijkstra the Father of the Computer Science, about BASIC, which is the basis for VBA (Visual Basic for Applications)

I think of the company advertising "Thought Processors" or the college pretending that learning BASIC suffices or at least helps, whereas the teaching of BASIC should be rated as a criminal offence: it mutilates the mind beyond recovery.

and he said that in 1984.