En cours

Excel VBA Optimization

[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.

Compétences : Programmation C, Visual Basic

Voir plus : vba optimization, excel vba optimization, optimization vba, vba optimize, excel vba optimize, optimize vba code, optimize excel vba, vba excel optimization, optimize vba excel, vba code optimization, optimize vba, optimization excel vba, optimization vba excel, optimization excel, excel vba optimisation, optimizing excel vba, optimizing excel, vba optimization code, optimizing vba excel, excel vba code optimization, vba excel optimize, visual basic excel optimization, convert excel vba dll, vba code optimize, optimize vba program

Concernant l'employeur :
( 0 commentaires ) Tubli, Bahrain

N° du projet : #56200

14 freelancers are bidding on average $64 for this job

NashTrump

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

70 $ USD en 0 jours
(12 Commentaires)
4.4
amanullahs

I can do this project. My expertise is VB with VBA with specialization in debugging, re-engineering, development and support. Awaiting your response.

65 $ USD en 1 jour
(1 Commentaire)
2.7
Progmatics

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 Plus

100 $ USD en 1 jour
(2 Commentaires)
2.8
rajiv0911

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

30 $ USD en 3 jours
(2 Commentaires)
1.7
shozayen

Dear Client I have fixed the code, but I want an excel file to test it. I appreciate your reply Best regards,

70 $ USD en 0 jours
(0 Commentaires)
0.0
juanjimenezd

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 Plus

35 $ USD en 1 jour
(0 Commentaires)
0.0
ismarodri123

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 Plus

30 $ USD en 3 jours
(0 Commentaires)
0.0
dicadio

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

40 $ USD en 1 jour
(0 Commentaires)
0.0
hiensys

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 Plus

100 $ USD en 10 jours
(0 Commentaires)
0.0
Omair

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 Plus

90 $ USD en 5 jours
(0 Commentaires)
0.0
carlos58ar

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.

90 $ USD en 3 jours
(0 Commentaires)
0.0
pug

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 Plus

100 $ USD en 3 jours
(0 Commentaires)
2.0
genio

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.

50 $ USD en 3 jours
(0 Commentaires)
2.0
marjo

Hi maman, your project really interest me. But I have some questions about the project. Please see the PMB.

30 $ USD en 3 jours
(0 Commentaires)
2.0
capr022

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

30 $ USD en 5 jours
(0 Commentaires)
0.0