Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

sarahnade

Programmer
Dec 22, 2005
49
US
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-
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top