Creating C++ DLL for my VBA code

E

ExcelMonkey

Can anyone provide me with an example of something in VBA which is quite slow
which I can then turn around and substitute with a C++ DLL?

I am looking to build a routine which shows the speed differences of using
VBA code vs VBA code referencing a C++ DLL. It really an excersise in
bulding and running C++ DLLs in VBA.

So effectively the routine will have two options (1 = VBA, 2 = C++). I will
then run the routine based on whatever option, and record the time taken to
finish the routine.

I will then figure out the C++ DLL piece once this first part is completed.
I have heard that matrix math might be a good example of this. Will likely
incorporate this into a looping structure for simulation purposes.

Thanks

EM
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Process steps to compile current VBA macros into a DLL or COM Addin 1
Can I still register a function in a DLL using ExecuteExcel4Macro REGISTER? 6
Must VBA be manually converted to VB.NET (C++;C#) to create a DLL or Com Addin? 6
problem with "file not found" calling a dll from VBA 6
Creating a DLL for Excel 3
Sample VBA code to open an Visual-Studio-2008-created VBA DLL 9
Accessing a C# dll from vba 1
32 bit DLL with 64 bit Excel 2010 13

Top