moving personal workbook

P

Perplexed

I have made several complicated and useful macros and
saved them in my personal workbook so they work on all my
Excel workbooks. Now I would like to use these on another
computer.

Is there more to it than just copying and overwriting the
personal workbook on my second computer.
 
N

Norman Harker

Hi Perplexed!

You can do that but it would wipe out any macros in the second
computer's Personal.xls.

Other ways are to
Export the modules to a folder,
Copy the *.bas created to a disk
Copy from the disk to your new computer
Import the modules to your personal.xls
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
M

Mark Worthington

Norman Harker said:
Hi Perplexed!

You can do that but it would wipe out any macros in the second
computer's Personal.xls.

Other ways are to
Export the modules to a folder,
Copy the *.bas created to a disk
Copy from the disk to your new computer
Import the modules to your personal.xls

Open a new workbook, and in the VBE editor, just drag the relevant
modules from personal.xls into the new book.

Reverse the process at the other end.

Mark
 

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