View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
Paul H[_2_] Paul H[_2_] is offline
external usenet poster
 
Posts: 55
Default How to save/move a personal workbook


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