How to save/move a personal workbook

[Paul H]

I have a number of spreadsheets in a personal workbook. When I move the
spreadsheets to another computer, how do I also the personal workbook that
has the macros I've recorded? TIA, Paul

 

[AB]

When you say 'personal' do you mean the PERSONAL.XLS that Excel opens
up when it starts?
If so, then the easiest is to move/copy the entire workbook and not
worksheets and macros separatelly.

As a general rule (for me anyway) is to not make the PERSONAL.XLS
overly a task specific, i.e., I'd store in the workbook on the macros,
that i'd use for general purposses and not for a specific workbook. If
you've got macros needed for a specific workbook - store/record those
macros in that workbook (and not PERSONAL.XLS) - then the macros
always follow the worksheets/spreadsheets.

 

[Nigel]

Your personal workbook is stored in your Excel xlstart folder which is
opened with xl but remains hidden. It's exact path will depend on the
version of xl and your system configuration.

Do a search for "personal.*" to find it and move / copy this to your new PC.

 

[Paul H]

Thanks Nigel. Can I put it in my folder with the spreadsheet, or must it be
in the comparable spot as in the "from" machine? My "from machine" is 2003
and XP. My "to machine" is Excel 2007 and Vista.

 

[Nigel]

It has to be in the xl start folder, as these are opened automatically when
xl starts up. You could arrange for other workbooks to open by redirecting
after xl loads a start up file. But in my opinion using the xl start up
folder is by far the easiest. In xl2007 my xl start folder is

C:\Users\Nigel\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB

--

Regards,
Nigel
(e-mail address removed)