Excel 2003 macro collection
 

I had to delete user WinXP profile, when user logged in new profile was
created but Excel 2003 macro collection and macro menu list was gone.
Where can I find users macroes - I beleive that they were saved as part of
Personal Workbook or something similar?
Any help greatly appreciated...

Excel 2003 macro collection
 

If they were in personal.xls (or .xla), you should be able to find them in the
XLStart folder.

Open excel
hit alt-f11 to get to the VBE
hit ctrl-g to see the immediate window

type this and hit enter:
?application.startuppath

for me (xl2003, winXP Home), I get:
C:\Documents and Settings\(username)\Application Data\Microsoft\Excel\XLSTART

But if you changed usernames, you may want to open windows explorer and drill
down to that old user's XLStart folder.

===
On top of that, the user could have had an addin that could be anywhere.

They could install the addin via
tools|addins
and browse to any location that was available--network drives included.



bluepuppet wrote:

I had to delete user WinXP profile, when user logged in new profile was
created but Excel 2003 macro collection and macro menu list was gone.
Where can I find users macroes - I beleive that they were saved as part of
Personal Workbook or something similar?
Any help greatly appreciated...

--

Dave Peterson

Excel 2003 macro collection
 

I found the solution.

Personal.xls is stored in following folder:
C:\Documents and Settings\(username)\App. Data\Microsoft\Excel\XLSTART

I copied XLSTART folder to new user profile and all macroes were there.

User will have to recreate the menues.

Next time i should search your forum better.

Thanks again....
"bluepuppet" wrote:

I had to delete user WinXP profile, when user logged in new profile was
created but Excel 2003 macro collection and macro menu list was gone.
Where can I find users macroes - I beleive that they were saved as part of
Personal Workbook or something similar?
Any help greatly appreciated...

Excel 2003 macro collection
 

You should be able to find the Excel11.XLB file in

C:\Documents and Settings\(username)\App. Data\Microsoft\Excel folder

That file stores all the Toolbar and Menu customizations. Copy it over to new
profile.


Gord Dibben MS Excel MVP

On Wed, 17 Jan 2007 13:02:01 -0800, bluepuppet
wrote:

I found the solution.

Personal.xls is stored in following folder:
C:\Documents and Settings\(username)\App. Data\Microsoft\Excel\XLSTART

I copied XLSTART folder to new user profile and all macroes were there.

User will have to recreate the menues.

Next time i should search your forum better.

Thanks again....
"bluepuppet" wrote:

I had to delete user WinXP profile, when user logged in new profile was
created but Excel 2003 macro collection and macro menu list was gone.
Where can I find users macroes - I beleive that they were saved as part of
Personal Workbook or something similar?
Any help greatly appreciated...