Where to put PERSONAL.XLS

[Walter Briscoe]

I am using Excel 2003 on Windows XP.

1) Let us say I log in as foo.
I find PERSONAL.XLS is expected to be in the folder
C:\Documents and Settings\foo\Application Data\Microsoft\Excel\XLSTART.
I have another system where PERSONAL.XLS is expected to be in the folder
C:\Program Files\Microsoft Office\OFFICE11\XLSTART
What controls where excel looks for PERSONAL.XLS?

2) I have some macros which reference a data file from PERSONEL.XLS.
I want to move both files to another machine.
It would be useful to put both files in the same folder - an
installation package is too heavyweight a solution.
Can somebody suggest code to identify the file containing the running
macro?

 

[royUK]

The best way would be to create an excel addin (*.xla) instead of
personal.xls.

 

[Peter T]

1. MsgBox Application.StartupPath

2. If you want to distribute code, as suggested, probably better in an
addin. It can go anywhere, typically easiest to put it here -

MsgBox Application.UserLibraryPath

Regards,
Peter T

 

[Ron de Bruin]

Hi Water, see also :
http://www.rondebruin.nl/personal.htm