How do I transfer Excel 2007 macros to another computer?

  • Thread starter Thread starter justd103
  • Start date Start date
J

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?
 
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.
 
Back
Top