|
Michael Kaden
Posts: 25
Joined: 2023-10-25
|
Hello Andrei,
on my new project I have a problem with registering and running the project on Excel. I have 2 Versions:
Version 03 work log ok - works perfect
Version 04 reg fails - we can not register or run or it
We checked all what we could find think of including the registry etc, but as we can switch between the 2 versions and when we go back to V 3 it works but then back to V 4 the problem is there.
Therefore, we think it comes from settings or code in the V4 project itself. But we cannot find it. and send a link for the download to
support@add-in-express.com
We can of course go back to Ver 03 and go o from there, but we really would like to understand what the problem is.
By the way during registering, we get sometimes a warning Debug/CyL.DLL can not be accessed, although the file is not Read Only and we checked with the resource manager that there is no program using it.:
Environment:
- Visual Studio 2019 Community
- VB.NET
- Add-in Express Excel COM Add-in
- Excel / Office 64-bit
- Windows 10
- Per-user registration under HKCU
- Registry key exists:
HKCU\Software\Microsoft\Office\Excel\Addins\CyL.AddinModule
LoadBehavior = 3
I really would appreciate some input to the cause of et problem.
Thank you very much and kind regards
Michael |
|
|
Andrei Smolin
Add-in Express team
Posts: 19225
Joined: 2006-05-11
|
Hello Michael,
AddinModule.vb files in both projects contain the same string:
<GuidAttribute("YOUR_GUID"), ProgIdAttribute("YOUR_PROGID")>
That string identifies the COM part of your COM add-in; say, items under {HKCU or HKLM}\Software\Microsoft\Office\{an Office application}\Addins are actually ProgIds of the add-ins registered with your Office.
Since the strings are identical, you actually use a single add-in. Although you switch from one code base to another, essentially this is the same add-in for 1) the COM system, and 2) for Office. If you want them to be different, use different GUIDs and ProgIds. Before changing these, unregister your add-in (both projects) and start the host application to make sure your add-in isn't mentioned e.g. in File | Options | Add-ins, and COM Add-ins dialogs.
Or, if you want these versions to be the same add-in, unregister the registered one before registering the other.
Regards from Poland (GMT+1),
Andrei Smolin
Add-in Express Team Leader |
|