Optimize excel vba code run faster

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.

Dovednosti: Excel, Visual Basic, Visual Basic pro aplikace, Windows API

Zobrazit více: excel vba code optmization, excel vba code optimis, excel vba code log websites, excel vba code open internet explorer, inventory excel vba code, optimize excel code run faster, excel vba code check add ins, excel vba code data web page, create domain class excel vba code, ftp connection excel vba code, excel vba code pull internet data, excel vba code save web page, excel vba code updater, vba code run faster excel

O zaměstnavateli:
( 2 recenzí ) Espoo, Finland

Identifikační číslo projektu: #17769838

Uděleno uživateli:


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 ca Další

€100 EUR za 2 dní
(15 recenzí)

17 freelanceů na tento projekt zveřejnilo nabídku v průměrné hodnotě €136


Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on and have been featured by the freelancer community ( Další

€222 EUR za 3 dní
(664 Recenzí)

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 Další

€200 EUR za 3 dní
(291 Recenzí)

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 Exce Další

€100 EUR za 3 dní
(386 Recenzí)

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 th Další

€111 EUR za 1 den
(88 Recenzí)

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 za 3 dní
(172 Recenzí)

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 Další

€155 EUR za 3 dní
(54 Recenzí)

masters in computer science with more then seven years of experience in Excel development and visual basics.

€250 EUR za 1 den
(53 Recenzí)

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 za 1 den
(64 Recenzí)

Hello How are you I read your description carefully It is very interesting to me I have many good experiences in vba and algorithm I think it is good way to improve the algorithm(program shedule) So I can finish Další

€100 EUR za 3 dní
(3 Recenzí)

Hello. As an Algorithm expert, I can help you. This is an easy task for me and I can give you perfect result by Monday. Let me help you, please. Looking forward to hearing from you. Regards. Denis.

€222 EUR za 3 dní
(2 Recenzí)

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 Další

€100 EUR za 1 den
(2 Recenzí)

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 Další

€100 EUR za 3 dní
(1 recenze)

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 f Další

€88 EUR za 3 dní
(2 Recenzí)

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 Další

€111 EUR za 1 den
(0 Recenzí)

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 za 3 dní
(0 Recenzí)
€100 EUR za 3 dní
(0 Recenzí)