I have VSTO ultimate and Excel 10, I want to do an Add-in for Excel in VB.NET
I am a VBA developer and I want to learn VB.NET, so I need a step by step guide to build my first Excel Add-in
I need a document with the explanation of the steps required to create the Add-in (example: creates a new project, add references, etc.)and source code.
I do not want step by step guide of the code, but only the code with comments. It must work on Excel 2007 and win 32/64 bit and must be redistributable, will load the first time and will remain in the add-ons.
Step 1) when it will be loaded, will create a new tab (name Black) in the Ribbon (img 1) and a new group (img 2) whit button called Black second.
Step 2)when the button (Black second) is clicked will create a new worksheet Data (img 5) as the image 3, without comments (numbers ending in column B to 30000). Now the user fills in the columns (img 4).
Step 3)when the button in worksheet Data (Button 1)is clicked will create a new worksheet "-" (img 6). Here I need to translate all the formulas in VB.NET .In this way, I see only the numbers and not formulas in [url removed, login to view] value of these cells (labels:num,peri,signal) should remain variable.
Step 4)build Add-in
In sheets, to explain myself better, I put the formulas with and without labels, I do not need any comments in Excel, but I want the commented code.
See the [url removed, login to view] file and ask me for any questions.