Can I copy Excell 2002 Macros from one Computer to another?

D

dutchoh1

How do I copy macros from one copmuter to another computer? I cannot seem to
figure out where Excel 2002 stores all of its Macros. There are a few
complex macros that I would like to transfer, but have no idea how.

Please help
Thanks
Brian
 
S

scott

I am sure some one will have a better solution.

It depends on where you saved the saved macros. There is a personal.xls
file that is where Excel store the macros may be stored. Search drive c
for that file. If the macros are in individual files, you can save the
file to the computer.

Using visual basic you can export modules.

HTH
 
G

Guest

hi,
Note: macros can be assign to a workbook, a sheet or can
be general. be sure to note where the macro was assigned
when exporting and import it to the same place in the new
file. otherwise, the macro may not work as expected.

open the vb editor. alt+F11
in the left pane, expand the project(file) that contains
the macro you want to export.
Right click the macro. click export. a dialog box will pop
up. export it to a floppy disk. it will export with a .bas
file extention.
once exported, remove the disk and insert it into a PC you
wish to install the macro.
open the vb editor(alt+F11).
in the left pane, right click the project you wish to
import the macro to. click import.
 
D

Dave Peterson

Macros live in workbooks.

If you share your workbooks with the macros with the others, then they'll have
them.

But try not to use a workbook name that the others may be using?
 
Top