Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 112
Default personal.xls in Excel 2007

I have an "old" computer running Win 2000 and Office 2000. Everything
is fine.

I have a "new" computer that is "virgin" (little or no customization)
that is running WinXP SP-3 and Office 2007.

How do I migrate everything that is in personal.xls on the old
computer to the new computer? Running a search doesn't even find
"personal.*" on the new computer.

Is this written up somewhere?

TIA

Fred Holmes
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 75
Default personal.xls in Excel 2007

you can create it e.g. by recording new macro and saving it to "personal
macro workbook" - from now on the file will be available


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,393
Default personal.xls in Excel 2007

Your Personal file is kept in the xlstart folder. You could copy the old one
to your new computer using a thumb drive. You need to locate the folders.
Here are some notes from XL2007 Help
-----
In Windows Vista, the path to the XLStart folder is usually:
C:\Users\user name\AppData\Local\Microsoft\Excel\XLStart.

In Microsoft Windows XP, the path to the XLStart folder is usually:
C:\Documents and Settings\user name\Application
Data\Microsoft\Excel\XLStart.

Tip You can locate the exact path to the XLStart folder in the Trust
Center.

How to locate the XLStart folder

Click the Microsoft Office Button , and then click Excel Options.
Click Trust Center, and then under Microsoft Office Excel Trust Center,
click Trust Center Settings.
Click Trusted Locations, and then verify the path to the XLStart folder in
the list of trusted locations.

______________

However, you should be aware that in classic Excel the personal file had XLS
as extension. You should open it in XL2007 and save it as a binary file XLXB

best wishes






"Fred Holmes" wrote in message
...
I have an "old" computer running Win 2000 and Office 2000. Everything
is fine.

I have a "new" computer that is "virgin" (little or no customization)
that is running WinXP SP-3 and Office 2007.

How do I migrate everything that is in personal.xls on the old
computer to the new computer? Running a search doesn't even find
"personal.*" on the new computer.

Is this written up somewhere?

TIA

Fred Holmes


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 - Personal Macros Susan Excel Worksheet Functions 1 April 5th 10 06:59 PM
Personal.xls and Excel 2007 Mike H Setting up and Configuration of Excel 0 October 4th 09 11:05 AM
Personal.xls Issues in Excel 2007 cardan Excel Programming 1 July 6th 08 10:27 AM
Personal.xls in Excel 2007 Peter K Setting up and Configuration of Excel 4 December 14th 07 08:56 PM
Personal.xls how can creat in excel 2007 Tufail Excel Discussion (Misc queries) 2 February 14th 07 10:25 PM


All times are GMT +1. The time now is 02:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"