Lengkap

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.

Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi, Windows API

Lihat lagi: 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

Tentang Majikan:
( 2 ulasan ) Espoo, Finland

ID Projek: #17769838

Dianugerahkan kepada:

rayyankabir

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 Lagi

€100 EUR dalam 2 hari
(4 Ulasan)
3.2

18 pekerja bebas membida secara purata €140 untuk pekerjaan ini

jaylancer43

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 freelancer.com and have been featured by the freelancer community ( Lagi

€222 EUR dalam 3 hari
(636 Ulasan)
8.3
schoudhary1553

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 Lagi

€200 EUR dalam 3 hari
(275 Ulasan)
7.6
SBITServices

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 Lagi

€100 EUR dalam 3 hari
(361 Ulasan)
7.3
zekovicm

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 Lagi

€111 EUR dalam sehari
(77 Ulasan)
6.7
avinav606lx

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 dalam 3 hari
(172 Ulasan)
6.5
usmanhassan123

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

€250 EUR dalam sehari
(38 Ulasan)
5.8
TechnoGuruu

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 Lagi

€155 EUR dalam 3 hari
(46 Ulasan)
5.2
aubrey03

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 dalam sehari
(51 Ulasan)
5.1
shiningdevelopor

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 Lagi

€100 EUR dalam 3 hari
(3 Ulasan)
3.5
dataexplorer

"Hello Dear, I can work for you as per your project description with amazing exploration and experimental research abilities. I am perfect for data entry that you may required. My work fulfills as well as keep you ret Lagi

€200 EUR dalam 7 hari
(9 Ulasan)
3.2
Ddvoryan

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 dalam 3 hari
(2 Ulasan)
2.7
maulikmakadiyase

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 Lagi

€100 EUR dalam sehari
(2 Ulasan)
1.9
frlncrsZviDAyqG

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 Lagi

€100 EUR dalam 3 hari
(1 Ulasan)
1.1
gpnr2017

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 Lagi

€88 EUR dalam 3 hari
(1 Ulasan)
0.8
EnriqueBet

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 Lagi

€111 EUR dalam sehari
(0 Ulasan)
0.0
BZGWI

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 dalam 3 hari
(0 Ulasan)
0.0
€100 EUR dalam 3 hari
(0 Ulasan)
0.0