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…

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s