Find Jobs
Hire Freelancers

Optimize excel vba code run faster

€30-250 EUR

Abgeschlossen
Veröffentlicht vor mehr als 5 Jahren

€30-250 EUR

Bezahlt bei Lieferung
We are a startup company making silicon hardware. Thousands of devices are fabricated on silicon wafers, and those devices need to be measured individually. We use an Excel VBA script to generate a table from some input tables, which eventually is used for controlling a measurement robot. This vba script used to work fine with an old version of excel (5 years ago or so) but does hang or executes very slowly with new excel (2016, version 1807). The vba runs two nested for loops over two ranges defined on two sheets of the excel file and writes out cells in another sheet. Two example files are provided: • one that runs ok (in some 10 secs on my thinkpad x230 i5 processor) • one that runs very slowly or fully hangs excel The slow-down problem of excel is related to how many iterations the loops go through, but this does not go proportionally to the number of iterations - there seems to be some threshold. The whole windows (7) operating system slows down when excel struggles with the vba code, so could it be some sort of system call problem? It also seems that excel does not consume very much of memory or processing power. Please look at the files and the excel code within. Run the VBA code by clicking the button "Create config sheet" on the "device_listing" sheet. The difference in the files is that in the one that runs slowly or hangs, "wafermap_64groups" has a larger selection of bolded cells which means more iterations in nested for loops. This can be an easy problem to solve for somebody with experience on VBA and it might not take more than 10 minutes for you. €100 is offered for the task.
Projekt-ID: 17769838

Über das Projekt

15 Vorschläge
Remote Projekt
Aktiv vor 6 Jahren

Möchten Sie etwas Geld verdienen?

Vorteile einer Ausschreibung auf Freelancer

Legen Sie Ihr Budget und Ihren Zeitrahmen fest
Für Ihre Arbeit bezahlt werden
Skizzieren Sie Ihren Vorschlag
Sie können sich kostenlos anmelden und auf Aufträge bieten
Vergeben an:
Avatar des Nutzers
Hello, I saw your code. The slowness is happening due to multiple loops on range level. If we just ignore the loop on range level and make it on memory using an array, it will be quick. As per my understanding, I can complete the task within 3-4 seconds. It's not either 10 min job or a full day job. I need around 3-4 hours to complete this task and €100 is fine. I am available this weekend and complete the task at the earliest. Please allow me to get started. Thanks, Rayyan
€100 EUR in 2 Tagen
5,0 (17 Bewertungen)
4,8
4,8
15 Freelancer bieten im Durchschnitt €133 EUR für diesen Auftrag
Avatar des Nutzers
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I can help you with Optimize excel vba code run faster I have more than 5 years of the experience in Excel, Visual Basic, Visual Basic for Apps, Windows API Please ping me for more discussion. Thanks.
€200 EUR in 3 Tagen
4,9 (325 Bewertungen)
7,9
7,9
Avatar des Nutzers
Hello usbcammaneger, I am waiting for your message and ready to do it now. I have opened the Macro and understood the issue.I have solution to improve its performance. I have 2.5 years experience in Excel VBA programming. I can complete task within time with 100% accuracy. With Regards, Sai
€100 EUR in 3 Tagen
4,9 (435 Bewertungen)
7,5
7,5
Avatar des Nutzers
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
€111 EUR in 1 Tag
4,9 (110 Bewertungen)
7,2
7,2
Avatar des Nutzers
Hey Mate, I’m looking into it. Let me try using some alternative codes to make it faster but ping me to initiate the project Thanks A
€100 EUR in 3 Tagen
4,9 (175 Bewertungen)
6,5
6,5
Avatar des Nutzers
Hi, As you want optimization of your Excel VBA macro so that it will run faster. I will do that for you. I have expertise in VBA macros. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Mohan
€155 EUR in 3 Tagen
5,0 (81 Bewertungen)
6,0
6,0
Avatar des Nutzers
I am an Excel VBA specialist. It is best if you will award this project to me because I am proficient in creating, debugging and optimizing VBA codes.
€100 EUR in 1 Tag
4,8 (124 Bewertungen)
5,9
5,9
Avatar des Nutzers
masters in computer science with more then seven years of experience in Excel development and visual basics.
€250 EUR in 1 Tag
4,7 (72 Bewertungen)
6,2
6,2
Avatar des Nutzers
Hello,  Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project. A brief summary of my profile as following. Over 12 years of experience in IT field of software development and support with  good verbal and written communication skills. On technical front I have good experience on following technologies. Databases : SQL Server, Universe/Unidata, Oracle,MS Access.  Development Technologies: C#,Winform, WPF, ASP.Net MVC, Pick Basic/UniBasic, Visual Basic 6, Excel VBA.  Reporting/Designer Tool: SSRS, Crystal Reports, System Builder(SB+). I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards,  Naveen Upadhyay
€88 EUR in 3 Tagen
5,0 (5 Bewertungen)
3,2
3,2
Avatar des Nutzers
Dear Sir, I am expert in performance improvement of any kind of code. You can see my review as well. I will improve the performance and solve your hang issue as well. I am able to replicate the issue as of now and will fix your problem quickly.. I have been in this industry for 8 years and such jobs are my daily practice. This is my first time on this site and hence you can see that I do have only 3 ratings/testimonials to show you. I can assure you that if you work with me once, you will always work with me for these kinds of projects. We Can discuss on call or in chat. Don’t worries I will give you the support for free of cost for any kind of issues. If you will give me a chance, I promise you that my work will always make you happy with excellent keys. Thanks, Maulik
€100 EUR in 1 Tag
5,0 (2 Bewertungen)
1,9
1,9
Avatar des Nutzers
Hello As you've discovered each new version of excel simply increases in size and complexity of non calculation functions at the cost of speed and efficiency in it's main purpose of calculating numbers. This is particularly noticeable when moving from Excel 5/2003 to 2016+ as I've found to our own cost recently with recursive functions However, there are a number of "tricks" and optimization changes that can be made both to the VBA function calling/methods and the running application framework that can significantly improve large iteration calculations. We can apply these to the main nested loops for you and test the speed improvement, but be aware it is very unlike to ever reach Excel 5 speeds even allowing for increased CPU power and memory available on modern laptops etc. due to the inherent overheads of the newer VBA architectures Regards Alan Sheppard
€100 EUR in 3 Tagen
5,0 (1 Bewertung)
1,1
1,1
Avatar des Nutzers
Hi my name is Enrique. I am developer with great experience in automation, I have found that this happens with the latest versions of VB. To avoid that slowness on your OS I think the solution is to create some python code that reads the input from the Excel file and generates the output in the same file. this will be really quick because no resources are spent on the User Interface. Please let me know if you are interested in this approach.
€111 EUR in 1 Tag
0,0 (0 Bewertungen)
0,0
0,0
Avatar des Nutzers
Expert with data entre, specific with Microsoft power query and the power BI Expert with data entre, specific with Microsoft power query and the power BI
€155 EUR in 3 Tagen
0,0 (0 Bewertungen)
0,0
0,0

Über den Kunden

Flagge von FINLAND
Espoo, Finland
5,0
2
Mitglied seit Apr. 17, 2018

Kundenüberprüfung

Danke! Wir haben Ihnen per E-Mail einen Link geschickt, über den Sie Ihr kostenloses Guthaben anfordern können.
Beim Senden Ihrer E-Mail ist ein Fehler aufgetreten. Bitte versuchen Sie es erneut.
Registrierte Benutzer Veröffentlichte Jobs
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Vorschau wird geladen
Erlaubnis zur Geolokalisierung erteilt.
Ihre Anmeldesitzung ist abgelaufen und Sie wurden abgemeldet. Bitte melden Sie sich erneut an.