|
Michael Kaden
Posts: 29
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: 19226
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 |
|
|
Michael Kaden
Posts: 29
Joined: 2023-10-25
|
Hello Andrei,
Thank you very much for the prompt reply, much appreciated.
Yes, we want to work with the same Add-In. The work flow will be:
When we have a well working and testes solution we back it up in say folder Ver 01. Then we copy the whole solution exactly as is into folder Ver 02. We then put Ver 02 on our server so some other member can download it and work on it. After that he uploads it and I download it and test it. If it is good we make it the new back up version, if not we start again with Ver 01. This gives us an easy way to return to “good” working projects. Is there any problem in doing that?
Registration! Thank you for mentioning to confirm with File | Options | Add-ins that the Add-In is unregistered. I actually think the above problem arose, when I only checked in the Excel UI that the AddIn was not there, but it actually, I think, was there as disabled AddIn.
The reaction we had was however quite drastic. When trying to open File | Options | Add-ins the Window did not open at all.
I assume that with our Versions, as they are identical, it will not matter if we register with one version and unregister with another version which has another code base?
Finally, we sometimes get a warning when building the solution or the project
“Unable to delete File “C\...........\Debug\CyL.dll Access to path is denied
The file is not Read-Only and has no handle in Resource Monitor. Also all users have full control of folders and sub-folders. Could that still be a problem with register/unregister?
Thank you very much and kind regards.
Michael |
|
Forums
Topics
Search
Help
Login
Register