[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
I can do this project. My expertise is VB with VBA with specialization in debugging, re-engineering, development and support. Awaiting your response.
You have 2 variables which slows down this very simple procedure, "PL" and "Buysig". "PL" being looped 10000 times and "Buysig", a staggering 65536 times! (you have referred to the entire column of your Excel sheet). I Daha Fazla
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 Client I have fixed the code, but I want an excel file to test it. I appreciate your reply Best regards,
Hi I have great experience in Vba. I have looked at the attached file and have some questions, But before making them I would like to take a look at the data you are processing. Could you provide the sample data and t Daha Fazla
I have large experience in Visual Basic for Excel (VBA). I can make it easily. Taking a look at the code, I noted it defines a lot of variables and is no need of defining each time the program runs this code. These var Daha Fazla
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
Dear Sir Hiensys IT Consulting is an emerging global technology services company delivering business solutions to its clients. We deliver the full range of application outsourcing, business process outsourcing, con Daha Fazla
HI, I am intrested in your project. I can provide you a quality solution. Links to previos work. [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] [url removed, login to view] Waitin Daha Fazla
Dear Sir: I have not the full program, but I think I can improve your performance once I can analyze the whole project. Best Regards.
Hi! I can offer you the solution with usage DLL on pure C. It will be the fastest variant. I had solved such task not long ago and its have increased operating speed greatly. I am ready to make this work for you. Send Daha Fazla
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 maman, your project really interest me. But I have some questions about the project. Please see the PMB.
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