Where to put PERSONAL.XLS

  • Thread starter Thread starter Walter Briscoe
  • Start date Start date
W

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?
 
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
 
Back
Top