Category Archives: MS Office

Using the Ribbon Control in MS Office 2007/2010 with C#

One of our clients has a complex Excel 2007 spreadsheet they need to do some automation with. The current solution involves lots of manual steps to create charts in a PowerPoint presentation. To this end I started researching how to add items to the ribbon bar so they could automate tasks with Macros.

However, when I started looking into it more deeply I discovered you could easily create plugins using Visual Studio and manipulate spreadsheets and most of the Office 2007/2010 suite using the Office.Interop DLL.

These are the helpful resources I used to get some development underway:

I did have some trouble with Windows 7 UAC because everytime you build your application, it reinstalls the plugin. There are some helpful posts about fixing this.

Next thing for me to learn and post about is doing something useful in C# to change the Excel Data…