Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
COM Addin doesn't link to workbook
I am using Excel 2002.
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. TIA, -- Joe VBA Automation/VB/C++/Web and DB development |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
COM Addin doesn't link to workbook
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
addin workbook | Excel Discussion (Misc queries) | |||
Signed workbook depends on physical location of AddIn - Digital Signature Invalid - workaround? | Excel Programming | |||
Digital signature on workbook/addin invalid when files moved? | Excel Programming | |||
Copying a Worksheet from an AddIn into an empty Workbook | Excel Programming | |||
Remove Excel AddIn from AddIn List !! Help | Excel Programming |