BF2...works.
MS Office...works.
VMWARE...works.
Of course I have no idea what VMWARE version or MS Office version you're runninng.
I guess if you have version 0.9 designed for Windows 3.1 you could have some issues, but
for anything that works decently on say Windows XP in general you'll have few or no problems.
Of course the safest answer is to check with the manufacturer for drivers for Vista 64 for all your hardware.
And the safest answer is to check with the software vendor for compatibility certifications / tips / patches for Vista 64 too. But in general I think you'll find that like 98% of things that were relatively "new" during the time XP was out (say from 2003-2008) will be OK.
The application software tends to be ok.. the exceptions are certain installer related issues or permissions type of issues where a few things don't like running without administrator access, but you can grant that and run them in 'compatibility mode' if you really have to.
Some things like drivers, punkbuster for BF2 / other games, anti-virus s/w etc. need or really should get free updates so as to best support vista.. but usually that is all available from either windows update or direct downloads from the vendors.
This is a great time to go Vista 64 and expand RAM... $133/8GB DDR2-800? I seriously doubt it can get much cheaper than that for at least a couple of years to come maybe when 4GB size DDR3 DIMMs start getting mainstream...