Using VS 2010 and C#, I need to determine whether to use an Excel Workbook project or Excel Addin project ?
I understand we have three main levels:
App-level, Doc-level, and Office UI customization
In my case I would like to add a new group to Excel representing my company's name, then roll that out to certain users.
I would like to create some Excel workbooks based on what menu option the users chooses. i.e. I've accomplished some of this already via Excel VBA, however I'd like to convert some of these VBA Report I've created into a C# project, then hook that into the Excel IDE.
The problem I have is understanding how to use all the Excel class in a Addin project.
For example, using http://msdn.microsoft.com/en-us/library/a0ytdsk6.aspx
as a guide I noticed these commands below are not recognized in my Addin project; they are only recognized in the Workbook project. I imagine I'm missing certain class references:
textInCell = this.Controls.AddNamedRang
", missing), "cellText");
textInCell.Value2 = "Hello world!";
Perhaps someone could lead me in the right direction.
Thanks ahead of time.