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.
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 Plus
17 freelance font une offre moyenne de €136 pour ce travail
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 ( Plus
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 Plus
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 Plus
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 Plus
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
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 Plus
masters in computer science with more then seven years of experience in Excel development and visual basics.
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.
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 Plus
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.
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 Plus
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 Plus
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 Plus
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 Plus
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