cancel
Showing results for 
Search instead for 
Did you mean: 

Macro locations

Macro locations
Occasional Visitor

Macro locations

I Recently gave a user a new Roaming profile. Unfortunatley the macros didnt copy over. Any Ideas where I can salvage the macros?
Are the macros attached with the profile?
4 REPLIES
Alan_152
Honored Contributor

Re: Macro locations

Is it an MS Word macro? Those are in normal.dot ...
Macro locations
Occasional Visitor

Re: Macro locations

Unfortunately they are Excel Macros, any ideas?

Thanks in advance

Jason
Igor Karasik
Honored Contributor

Re: Macro locations

Excel macros stored in in the applicable workbook or in personal.xls
http://office.microsoft.com/en-us/assistance/HA010872961033.aspx
Richard Darling
Trusted Contributor

Re: Macro locations

If the user was creating many macros they would probabaly have saved them into their personal.xls spreadsheet, and kept it open but hidden. It would probably be located in:

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

This would allow the personal.xls to open when they opened excel, allowing access to run the macros.
rdarling@southwickclothing.com