Excel add in with C++... fool's errand?

[sarahnade]

Before I worked here, the guy before me wrote an add in for Excel. There is a handy little Development tab to accommodate VB, so that is what he used to write it. The problem is that we use this function in over a hundred cells and his function is reeeeally slow. It takes usually 5 to 10 minutes for the sheet to recalculate.

My goal is to rewrite his code to make it faster. I am not familiar with VB and would like to simply rewrite it in C++. However, there is no handy C++ tab in Excel. The only instructions I've seen are Microsoft's and they look complex and messy.

Has anyone done this? Do you know of any resources I can look at? Is my time better spent getting to know VB and writing it that way?

(For now) I'm using Visual C++ Express and writing for Office 2007.

Thanks!

Sarah
-don't panic, I'm mostly harmless-

 

[Demonpiggies]

I don't know if this will help but there is a little PDF (link:

http://www.maths.manchester.ac.uk/~ahazel/EXCEL_C++.pdf)

that on page 56 explains a way to create a vc++ add-in for Excel. I hope this helps.