ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Creating C++ DLL for my VBA code (https://www.excelbanter.com/excel-programming/356920-creating-c-dll-my-vba-code.html)

ExcelMonkey

Creating C++ DLL for my VBA code
 
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


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com