topic Re: Macro locations in Operating System - Microsoft

Macro locations

Macro locations — Tue, 14 Feb 2006 03:52:42 GMT

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?

Re: Macro locations

Alan_152 — Wed, 15 Feb 2006 12:53:50 GMT

Is it an MS Word macro? Those are in normal.dot ...

Re: Macro locations

Macro locations — Thu, 16 Feb 2006 04:01:41 GMT

Unfortunately they are Excel Macros, any ideas?

Thanks in advance

Jason

Re: Macro locations

Igor Karasik — Thu, 16 Feb 2006 05:51:08 GMT

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

Re: Macro locations

Richard Darling — Thu, 16 Feb 2006 08:49:25 GMT

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.