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