Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel Macro's 1
- Thread starter Sopman
- Start date
Personal.xls - if you had one before
Otherwise, they are just stored in the workbooks themsleves
ps - for future ref this should really be asked in the VBA forum (Forum707)
Rgds, Geoff
"Errors have been made....Others will be blamed"
Please read FAQ222-2244 before you ask a question
Otherwise, they are just stored in the workbooks themsleves
ps - for future ref this should really be asked in the VBA forum (Forum707)
Rgds, Geoff
"Errors have been made....Others will be blamed"
Please read FAQ222-2244 before you ask a question
-
1
- #3
Try:
%USERPROFILE%\Application Data\Microsoft\Excel
And
%USERPROFILE%\Application Data\Microsoft\Excel\XLSTART
where %USERPROFILE% is usually 'C:\Documents And Settings\your_lan_id' (in XP w/Excel 2000)
FYI: The XLSTART directory contains the auto-loading macros
%USERPROFILE%\Application Data\Microsoft\Excel
And
%USERPROFILE%\Application Data\Microsoft\Excel\XLSTART
where %USERPROFILE% is usually 'C:\Documents And Settings\your_lan_id' (in XP w/Excel 2000)
FYI: The XLSTART directory contains the auto-loading macros
- Thread starter
- #4
- Status