Restoring Excel2K macro's from saved Win2K user profile

[JohnMo]

I need some insight regarding Excel 2000, macro's that
were created, and the need to restore these macro's so the
user does not have to recreate them.
I had to rebuild a users Win2000 user profile, and in the
process, all went great regarding getting old
configurations restored, EXCEPT his Excel macro's.
I tried replacing his old Excel info from the old profile,
but no macro's were there.
Does anyone know where in the old user profile these
macro's would be stored?
I feel that they are somewhere in the Local settings or
Application data, but have been unable to locate them to
restore.
As always, your expertise is greatly appreciated, should
you be able to give me some direction here.
Thanks
John Mo

 

[Jim Rech]

Macros can be stored in _any_ workbook. If you're talking about macros that
may have been recorded in the user's Personal.xls they are typically in a
folder like:

C:\Documents and Settings\<username>\Application
Data\Microsoft\Excel\XLSTART

--
Jim Rech
Excel MVP
|I need some insight regarding Excel 2000, macro's that
| were created, and the need to restore these macro's so the
| user does not have to recreate them.
| I had to rebuild a users Win2000 user profile, and in the
| process, all went great regarding getting old
| configurations restored, EXCEPT his Excel macro's.
| I tried replacing his old Excel info from the old profile,
| but no macro's were there.
| Does anyone know where in the old user profile these
| macro's would be stored?
| I feel that they are somewhere in the Local settings or
| Application data, but have been unable to locate them to
| restore.
| As always, your expertise is greatly appreciated, should
| you be able to give me some direction here.
| Thanks
| John Mo
|