moving personal workbook

[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.

 

[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.

 

[Mark Worthington]

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