Copying macros

M

Michael Kahn

I placed a number of macros in personal.xls on one
machine. I'm trying to move those macros to another
machine. How can I copy those macros from personal.xls to
another spreadsheet? Also does anyone know why I have so
much trouble copying personal.xls. Thanks. Michael
 
P

Paul B

Michael, I would export the macro, to export a macro and save it, do this
from your workbook, right-click the workbook's icon and pick View Code. This
icon is to the left of the "File" menu this will open the VBA editor, click
on the module you want to save and go to file and export file, then save it
to a floppy or what ever you backup to, then import it to the new workbooks

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **
 
S

steve

Michael,

You can just drag the macros from one workbook to another in the VBE.
Just open the workbook and start dragging and dropping...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top