Hi Joe,
I wrote a COM Addin in VB 6 and have set it to load on Excel's startup. I
have a sales person for whom this simple does not work. When I manually go
into Excel on her machine and manually load the COM Addin, Excel doesn't
retain the reference. If I load it, close Excel, reopen Excel and check to
see if it is still loaded, it isn't; if I load it and then check immediately
afterwards to see if it is still loaded (before closing Excel), it isn't.
Does anyone have an idea what could be going on here? If I need to provide
more information, please let me know.
This is pure guesswork, but:
(a) Is her registry access blocked? The DLL needs to write to the registry to
store its load behaviour etc.
(b) Is the dll blocked by Excel (check in Help About Disabled items)
(c) Is there any code in the OnConnection event that's causing the dll to fail?
Regards
Stephen Bullen
Microsoft MVP - Excel
www.BMSLtd.ie