moving personal workbook

  • Thread starter Thread starter Perplexed
  • Start date Start date
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.
 
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.
 
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
Click to expand...

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