Excel file that holds environmen data

[TheBionicOrange]

Anyone know how to find the Excel environment file ?

I had Crystal Reports, which in turn put an icon on the toolbar.
Then Crystal got binned, but whenever I fire up Excel its obviously still looking for the icon as it throws up an error.
I can get in OK after that, its just annoying, so I presume theres maybe an .INI file somewhere where I can remove the reference to it ?

[Hack]

See what you find under C:\Documents and Settings\YourLogInId\Application Data\Microsoft

[RobDog888]

Two locations to check out.

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

[Hack]

I was close.

I forgot to add the Excel\XLSTART. :D

[RobDog888]

More then likely its in the Add-In folder but I cant verify this as my version of CR doesnt add anything to Excel. Its probably too old. :(

[TheBionicOrange]

OK nothing in XLSTART directory, and 1 file in ADDINS directory called CRPTACCWZ2K.MDE.
Tried moving this out but still had same problem.
Excel still looking for :

C:\Program Files\Seagate Software\Report Designer Component\CRPTXLS.XLA.

Grrr !

[RobDog888]

How about -
?:\Program Files\Microsoft Office\OFFICE11\ADDINS
?:\Program Files\Microsoft Office\OFFICE11\STARTUP
?:\Program Files\Microsoft Office\OFFICE11\MACROS

[TheBionicOrange]

Nothing obvious in \Addins. Only a couple of files in there.
Don't have a \STARTUP or a \MACROS directory using that path.
I'll see if they exist under a slightly different path.

[TheBionicOrange]

OK found them under C:\Program Files\Microsoft Office\Office ... but no not in those other 2 either !

[RobDog888]

There is also a personal and public macros folder somewhere but I cant remember off hand. How about searching the registry for anything that may show it placing the startup info for Excel to add the toolbuttons in?

[TheBionicOrange]

Good point.

Give me 10 minutes and I'll be back asking for links to "Registry Rebuilding Software" !!

:)

[RobDog888]

:lol: Ok.

I had looked for any obvious keys but not having a newer version of CR I dont think I have the same feature as you.

[TheBionicOrange]

Cheers Rob. Found 2 entries ... deleted them both ... job done :)

AND no need for a rebuild :)

At least ... not yet as far as I know !

Thanks a lot for your input.

[RobDog888]

NP :) But could you post the locations in the registry that contained the offending load?

[TheBionicOrange]

oops !

I would if I hadn't already quit REGEDIT !

[RobDog888]

Regedit should reopen to the last location you were in. One out of two wouldnt be bad. :)

[TheBionicOrange]

OK.

The second one was found in :

HKEY_CURRENT_USERS\Software\Microsoft\Office\9.0\Excel\Options

[RobDog888]

Ok, Thanks.