Hi,

I have approx 30 macros stored in Excel, but now my boss has given me a new PC and is using my old one for a separate task. Both PCs are connected to our network.

Is there a way I can copy my macros from one PC to the other, for example by exporting them to a shared network location and then using the new PC to import them from there?

Do macros all reside in one file/location/whatever?

Old PC is running Windows 2000 Professional.
New PC is running Windows XP Professional.

What file(s) would I copy from the old PC?
Where should I store these on the new PC?

Thanks!

Howdy. In VBE, in the Project Explorer, if you right click on a module, you can see where it says, "Export module", you can set a location. It will be a .bas file. Once all the modules are exported, then you can import them into VBE.