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: 18829
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.
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
|
|