How do we apply this sample?

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

How do we apply this sample?
Working with Excel tables & Ranges: VB .NET code samples 
Leon Lai Kan




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

I am trying my hand at this sample:

Working with Excel workbooks and worksheets: VB.NET examples
https://www.add-in-express.com/creating-addins-blog/2013/10/09/excel-workbooks-worksheets-vbnet-examples/

This sample contains a lot of interesting Subs:
Sub InsertColumnOrRows
Sub CreateTable
etc


OK!
So, I build the project, and run debug.
Excel opens, but nothing happens.

Please give me an example how I can use the codes in the sample.

Thanks
Leon
Posted 10 Jan, 2019 05:55:46 Top
Andrei Smolin


Add-in Express team


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

You need to register the project. I've done this and the add-in does load and create its Ribbon tab in Excel 2016-2019 for me.


Andrei Smolin
Add-in Express Team Leader
Posted 10 Jan, 2019 06:53:40 Top
Leon Lai Kan




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

I did register the project.

There is no ribbon tab in the sample project.

Maybe this is the reason why my Excel Sheet is blank?
You need to create buttons and add code to the click events?


Thanks
Leon
Posted 10 Jan, 2019 07:19:37 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
Leon,

Then the add-in is disabled: check the disabled items dialog (it is also mentioned in the manual) and re-enable it.

When you register that add-in project, it suggests replacing loader: did you do that or not? The answer is required to point you to the loader log file location.


Andrei Smolin
Add-in Express Team Leader
Posted 10 Jan, 2019 07:25:59 Top
Leon Lai Kan




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

It's ok now.

In trying to learn too fast, I messed up different sample downloads :>

Best Regards,
Leon
Posted 10 Jan, 2019 08:06:37 Top
Andrei Smolin


Add-in Express team


Posts: 18793
Joined: 2006-05-11
No problem. This happens.


Andrei Smolin
Add-in Express Team Leader
Posted 10 Jan, 2019 08:10:39 Top