How do I transfer Excel 2007 macros to another computer?

[justd103]

We are upgrading to new computers in my office. How do I copy my Excel 2007
macros from the old computer to the new computer? Would the procedure be the
same if I want to copy some of my Excel 2007 macros to a coworker's computer
for him to use?

 

[Shane Devenshire]

IT should transfer all of your data from the old computer to the new one.
There are many programs for doing that.

If you just want to copy macros from your files to someone elses, you can
copy the files containing the macros. There are other ways, for example, in
the VBA area you can right-click a module and say Export File, on the other
machine you can choose Import File from the File menu in the VBE.