When I uninstall an add-in from excel by uninstalling the application that
install the add-in when launching excel after the add-in has been removed
excel says that it can't find the add-in. Is there a way to do this so that
the a user is not given the error dialog?

Yes:
by deactivating the addin within the excel instance
THEN deleting the file.

OR if excel is NOT running by deleting
the OPENxxx value in the registry under

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Hoffy wrote :

When I uninstall an add-in from excel by uninstalling the application
that install the add-in when launching excel after the add-in has
been removed excel says that it can't find the add-in. Is there a way
to do this so that the a user is not given the error dialog?

"Rob Hoffy" <Rob wrote in message
...
When I uninstall an add-in from excel by uninstalling the application that
install the add-in when launching excel after the add-in has been removed
excel says that it can't find the add-in. Is there a way to do this so
that
the a user is not given the error dialog?

Select Tools|Add-ins. Remove the macro. You will get the same error message.
Excel will not save the information that the add-in shouldn't be loaded
until you exit Excel.

7fredrik

any suggestions of doing this automatically(scripted) since the open value
could be different on each persons machine and if you delete OPEN1 and only
have OPEN, OPEN 2, OPEN 3, etc only OPEN will get loaded since it reads them
sequentially.

"keepITcool" wrote:


Yes:
by deactivating the addin within the excel instance
THEN deleting the file.

OR if excel is NOT running by deleting
the OPENxxx value in the registry under

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options




--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Hoffy wrote :

When I uninstall an add-in from excel by uninstalling the application
that install the add-in when launching excel after the add-in has
been removed excel says that it can't find the add-in. Is there a way
to do this so that the a user is not given the error dialog?

I am working on a VERY elaborate VBscript...:

checking if excel running.
done. with WMI!
reading registry entries.
done. enumming with WMI, reading with wscript.shell

checking files exist.
done: basic scanning for all installed/opened files found in
registry...
todo: checking on duplicate installs in various folders.
todo: checking for duplicate document titles...

(since document titles are used as unique index in the addins
collection, you cannot have 2 entries with the same title..

options to install/activate/uninstall done.
options to scan multiple excel versions. done.
options to open addins as readonly (/R parameter)

etc..

deciding which addins to remove or add...
deciding if and when to kill/rename/move files


Rebuilding the OPEN series under options...
That's a very minor problem.


IF and when I get it working I'll make sure I advertise it :)


--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Hoffy wrote :

any suggestions of doing this automatically(scripted) since the open
value could be different on each persons machine and if you delete
OPEN1 and only have OPEN, OPEN 2, OPEN 3, etc only OPEN will get
loaded since it reads them sequentially.

"keepITcool" wrote:


Yes:
by deactivating the addin within the excel instance
THEN deleting the file.

OR if excel is NOT running by deleting
the OPENxxx value in the registry under

HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\E xcel\Options




--
keepITcool
www.XLsupport.com | keepITcool chello nl | amsterdam


Rob Hoffy wrote :

When I uninstall an add-in from excel by uninstalling the
application that install the add-in when launching excel after
the add-in has been removed excel says that it can't find the
add-in. Is there a way to do this so that the a user is not given
the error dialog?