administration mode
Pssst...Ferdy is the creator of JungleDragon, an awesome wildlife community. Visit JungleDragon

 

Developing an Excel 2007 add-in »

FERDY CHRISTANT - APR 13, 2008 (02:16:14 PM)

People have been writing Microsoft Office add-ins for years. They are a great way to extend the power of your office productivity suite. There is obviously also a great downfall, as it locks you into an office suite and makes version upgrades harder.

Without worrying about all this, today I played around with a new Visual Studio 2008 project type: the Excel 2007 Add-in. This project type makes it super easy to develop your own Add-in. You can visually create an add-in Ribbon, place controls on it, and link it to code events. You can directly debug the code you develop in Excel. Below is my shot at creating a simple plug-in, for the sake of experimentation:

Note the black arrow. This is the custom "Blog" Add-in, placed in its own Ribbon. By clicking "Load Blog", the entries from the online blog are placed in the active worksheet. I used a test copy of Blogo.NET to connect to. By clicking "Subscribe", the blog feed is added to your feed reader.

The functional value of this test case is of course none, but I just wanted to find out how this stuff works nowadays. If you're interested to know how I developed this, please refer to this article. I used the article as a base to get started, and then customized the code to fit my needs.

Whilst I remain skeptical of building a lot of functionality in client applications, one has to acknowledge how comfortable end users are with Office applications. The best practice I can come up with would be to not write business logic in such extensions, instead the extension must link up with server-side data or services only. What do you think?

Share |

Comments: 4

COMMENT: ROSS CULVER email

MAR 2, 2009 - 04:19:20 PM

comment » Ferdy,

I know that you posted this document last year, so excuse me for my tardiness.

I downloaded your solution but since I'm still on VS2K5 could not open it. Does it include a setup project?

I'm struggling to deploy my Excel 2K7 addins and cannot find any clear instructions. I found some information for adding the registry entries, but I cannot get my addins to work, even though they appear in the Com Addins list.

Could you point me to some relevant information?

Thanks,

Ross «

COMMENT: REKA

NOV 16, 2010 - 10:08:17 AM

comment » IT WAS VERYMUCH USEFUL.THANKS. ! 01 «

COMMENT: VEENA email

DEC 16, 2010 - 06:45:39 AM

comment » Hi,

can we use the addin that was developed in Excel 2007 to Excel 2010. I have uninstalled 2007 and installed Office 2010. Error occurs on loading the previously developed 2007 addin.

Any help? «

COMMENT: JOHN email

JAN 19, 2012 - 08:01:08 AM

comment » Hi,

I wants to develop an excel plugin. My question is which free edition of Visual Studio supports excel plug in development or is there any third party development environment for excel plugin development?. Please help me on this since I am new to the plugin development and for Microsoft technologies.

Thanks in advance. «

RATE THIS CONTENT (OPTIONAL)
Was this document useful to you?
 
rating Awesome
rating Good
rating Average
rating Poor
rating Useless
CREATE A NEW COMMENT
required field
required field HTML is not allowed. Hyperlinks will automatically be converted.