Đang Thực Hiện

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.

Kỹ năng: Lập trình C, Visual Basic

Xem thêm: 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

Về Bên Thuê:
( 0 nhận xét ) Tubli, Bahrain

Mã Dự Án: #56200

14 freelancer đang chào giá trung bình $64 cho công việc này

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 trong 0 ngày
(12 Đánh Giá)
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 trong 1 ngày
(1 Đánh Giá)
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 Thêm

$100 USD trong 1 ngày
(2 Đánh Giá)
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 trong 3 ngày
(2 Đánh Giá)
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 trong 0 ngày
(0 Đánh Giá)
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 Thêm

$35 USD trong 1 ngày
(0 Đánh Giá)
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 Thêm

$30 USD trong 3 ngày
(0 Đánh Giá)
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 trong 1 ngày
(0 Đánh Giá)
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 Thêm

$100 USD trong 10 ngày
(0 Đánh Giá)
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 Thêm

$90 USD trong 5 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
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 Thêm

$100 USD trong 3 ngày
(0 Đánh Giá)
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 trong 3 ngày
(0 Đánh Giá)
2.0
marjo

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

$30 USD trong 3 ngày
(0 Đánh Giá)
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 trong 5 ngày
(0 Đánh Giá)
0.0