I have been quiet in the last few weeks. I wasn't hibernating. I was simply over-busy!

But I took some time to write an article on something I really had to do!

Two weeks ago, I was asked by a user to provide access to some data of one of their database so that they can use it directly from Excel. I first suggested some methods that are already implemented in the application (like extracting the data and use it in a lookup table). But nothing could satisfy him. He has one idea in mind: being able to use a formula to have access to the data (ie: GetData(value1, value2)) much like Bloomberg and many others vendors are providing.

It was time for me to dig into the creation of an add-in which I knew it was possible but I never built. So guess what is my article all about this month?

You can read the full article from http://www.emoreau.com/Entries/Articles/2010/06/Creating-Excel-Add-in-with-VBnet-or-C.aspx