VBA offers marvelous functionality, but being an interpreted language, it is very slow compared to worksheet functions. I would like to compile all or most of the subroutines in my application so they run much faster, hopefully at least 10 times faster. I believe that you have to first convert the VBA code to another language, such as VB or C++, and then use a compiler for that language to create a dll or xll, which can then be referenced in the Excel file.

I have been searching the Internet for products that would do this work for me. So far I haven't found much; perhaps I'm not searching the right way. Can anyone suggest specific software for this purpose?

Some of the products I've seen will also compile the worksheets as well as the VBA code, with the intent of hiding proprietary formulas and/or transforming the entire application into a .exe. That's nice, but I don't need that, at east not yet. I just want to make the VBA code run much faster without losing any functionality.

Would appreciate any recommendations and words of wisdom.