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

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.

On 20 July, 05:41, "Paul H" wrote:
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

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.

--

Regards,
Nigel




"Paul H" wrote in message
...
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

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" wrote in message
...
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.

--

Regards,
Nigel




"Paul H" wrote in message
...
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

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\XLS TART\PERSONAL.XLSB

--

Regards,
Nigel




"Paul H" wrote in message
...

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" wrote in message
...
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.

--

Regards,
Nigel




"Paul H" wrote in message
...
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