Posted 29 September 2008 - 07:57 PM
I don't know Excel 2007 nor Vista.
But the usual way to copy macros brute force would be to open the VBA toolbar, get into the Modules, select each, and Export one by one. Then import into 2007 modules if Excel 2007 VBA permits that.
If export/import doesn't work, you can always copy out the entire text into Notepad text files, and copy/paste from the Notepad into your 2007 Excel.
If the VBA language or object model has changed between 2000 or 2003 and 2007, then some tweaking might be in order, but I suspect they left it alone, and the error messages, if any, might suggest what to fix.
Since these are different computers, either network them and share some common directory, or use USB flash drive for transfers of the, say, Notepad files.
Export is good, because it names the modules. They get saved someplace in your local settings. Notepad will not name, and doesn't matter really.