PERSONAL.XLS

  • Thread starter Thread starter Khalil Handal
  • Start date Start date
K

Khalil Handal

Hi,
Need to know about PERSONAL.XLS ?
What it is used for ?
Where it is stored? .....
Other information.... etc.

Khalil
 
I don't have any idea about it. I notices that some people from the groop
knows about it and use it.
I want to get benefit of it and use it in my workbooks specially if t makes
thing more easy.
 
personal.xls is a workbook (usually hidden) that is kept in your XLStart folder.

In general, it contains macros and functions that the user wants to have
available whenever they open excel.
 
My Excel Start Folder can be any place or in specific folder???

and

Thanks for the help

Khalil
 
The location of that folder depends on the version of windows and the version of
excel (and even your upgrade path).

I like this way to find the XLStart that excel likes:

Open excel
hit alt-f11 (to get to the VBE where macros live)
hit ctrl-g (to see the immediate window)

type this and hit enter
Print application.StartupPath

For me (xl2003 and winxp), I get:
C:\Documents and Settings\(username here)
\Application Data\Microsoft\Excel\XLSTART
(all one path)

==
Some people record macros directly into their personal.xls file for common
routines. I've always recorded into a test workbook, then tweaked the recorded
code. After I was happy with it, I'd just highlight the code and copy|paste to
a module in my personal.xl* workbook project.

If you're going to be experimenting, remember to back up your personal.xl* file
often. If you screw up, you'll be able to copy the older version back to the
XLStart folder.

(It's very easy to screw up when you're doing stuff.)
 
Back
Top