Where is Personal.Xls

T

Thrava

I want to copy the macros, or the whole file called
Personal.xls where I've recorded some macros to.
But when I try to find it, I come up with
nothing...searching for Personal.xls
 
D

Don Guillett

try using windows FIND and just search all files, including hidden for it.
 
T

Thrava

Did that,
Its not finding it. Can this file be called differently?
and only displays as "Personal"?
 
G

Gord Dibben

Thrava

If you have one it will reside in

C:\Documents and Settings\username\Application\Data\Microsoft\Excel\XLSTART

Personal.xls is created the first time you record a Macro using Macro
Recorder.

Tools>Macro>Record New Macro. A dialog box will come up asking you name the
macro and where to place it. Pick Personal Macro Workbook from the dropdown.
Copy and paste a couple of cells then Stop Recording.

You now have a Personal.xls in your Office\XLSTART folder. You can go to
Visual Basic Editor(Alt+F11) to view the macro you just recorded in a Module.

You can add more macros by recording or by typing them into the Module.

You can do a File>Save from there or better yet hit ALT + Q to return to the
Excel window.

Then with Personal.xls active, hit Window>Hide.

When you close Excel you will be asked if you want to save Personal.xls. Yes!

It will open hidden next time you start Excel.

If you believe you already have a Personal.xls, look for it on your HDD using
Start>Search>For File and Folders.

Start>Search>For Files and Folders and look for *.xls

Make sure you have Tools>Folder Options>View>Files and Folders set to "show
all files"


Gord Dibben Excel MVP
 
J

Jay Somerset

Did that,
Its not finding it. Can this file be called differently?
and only displays as "Personal"?
Click to expand...

Sounds as though you are suppressing the extension on listings within
Explorer. Go to Tools|Folder Options|View and uncheck the box that says
"Hide file extensions for known types" Also, check the button that says
"Show hidden files and folders"
 
Top