[url removed, login to view] Current Situation:
Attached is an Excel VBA Function that is a part of an Excel VBA program. The function is called 1000s of times during the runtime of the program.
[url removed, login to view] Problem:
The program runs very slow.
[url removed, login to view] Required Task:
To optimize, re-write, the code of the function so that it runs faster.
[url removed, login to view]:
-There is an array in the function called "PL". This array is defined outside the function as Public.
-If the bidder is capable of converting the function to C++ compiled DLL that can be called from the VBA program, please mention this and bid for it.
14 freelancers are bidding on average $64 for this job
hi there, i am an expert in vba. can you give me an example of a procedure and some details that run this code, then i can completely fix this code so it runs much faster. Kind regards, Nash
Dear Sir, Though I did not get any reply from you for the query that I raised here I would like to give you a solution in VBA itself. Please send me the excel VBA with sample data. Thanks and Regards, Rajiv
Dear Sir, I have experinced in VBA macro in excel, and if you want that function become dll let me help you i can make in VB, C# or C++ , but I want to know more detail about your want. Thanks
I have more than 12 years of C++ programming experience. Besides, I built a Word Add-in and have made some VB programs. So I can very well translate that VB code to a C/C++ DLL.
Hi, I don't think converting vba to dll will give a good optimization method. coz., any way loop will run for 10000 times. we must try to change vba code or logic in vba itself. thanks