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-
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-