I cannot make a blog sample work. What's wrong?

Add-in Express™ Support Service
That's what is more important than anything else

I cannot make a blog sample work. What's wrong?
Working with Excel workbooks and worksheets: VB.NET examples. 
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi,

If I have a question concerning a blog, should I ask the question on the blog or on this forum?

I have already asked the question below on the blog.

Sorry for the duplicate.





Hi,
I am a newcomer to ADX, and I am learning from the Blog samples.

At present I am working on this sample:
Working with Excel workbooks and worksheets: VB.NET examples.


Here are my steps:
I unzipped your sample.
I opened Visual Studio 2010 as administrator.
I successfully BUILT the project.
Then I successfully REGISTERED the project.
Then I START DEBUGGING

Well, the Excel workbook opens, but I don’t see any trace of the add-in in Excel.
I tried dozens of times (unregistered and registered again), but still no trace of the add-in in Excel.

What’s more annoying, is that on one occasion, the add-in tab and consorts actually did appear, and I have been able to play with the buttons to see what happens.
But I could not reproduce the happening.

So, what have I done wrong?
Is this the correct way to run your add-in?
Thanks
Leon
Posted 31 Dec, 2018 02:15:45 Top
Andrei Smolin


Add-in Express team


Posts: 17243
Joined: 2006-05-11
Hello Leon,

Check if the add-in is disabled. Check section Add-in is Disabled in the .PDF file in folder {Add-in Express installation folder}\Docs.

I suppose you reset the debugging session and Office interpreted this as a crash produced by your add-in. To avoid this scenario, always let the host application quit normally.

Regards from Belarus (GMT+3),

Andrei Smolin
Add-in Express Team Leader
Posted 31 Dec, 2018 04:55:23 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

I thought that maybe my path was too long:
F:\Add-in-Express\BLOGS\Working with Excel Workbooks and worksheets\Working with Workbooks\WorkingwithWorkbooks.vbproj


I shortened the path to:
F:\TEST\Working with Workbooks\WorkingwithWorkbooks.vbproj


I don't know if this is the explanation, but it now works.

Thanks
Leon
Posted 31 Dec, 2018 05:26:33 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

No, my explanation is not correct.

Even with the shortened path, the add-in crashed again, and the add-in tab "WORKING WORKBOOKS" does not appear in the Excel Ribbon.



I suppose you reset the debugging session and Office interpreted this as a crash produced by your add-in. To avoid this scenario, always let the host application quit normally.



If I accept your explanation, I am still in a position that the add-in does not show up in the Excel Ribbon.

What must I do to make it appear?
I mean: How can I Register the add-in (in debug mode) in Excel?

Thanks
Leon
Posted 31 Dec, 2018 05:52:15 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
In Excel, I go to:
File > Options > Add-ins

I notice that my add-in is disabled:

Disabled Application Add-ins
WorkingWithWorkbooks
Location: F:\TESTS\WorkingWithWorkbooks\bin\Debug\adxloader.dll
.
.

So, how can I remove the disabled Add-in, and Register anew?


Leon
Posted 31 Dec, 2018 06:33:10 Top
Leon Lai Kan




Posts: 200
Joined: 2018-12-20
Hi, Andrei

I found how to enable the add-in in Excel.

Thanks, and no need to reply

Leon
Posted 31 Dec, 2018 06:38:36 Top