VBA Excel progect need speeding up

Hello! I took a look over the Excel file. can you tell me from where it is taking the info? I did not ran the cript from security reasons. You will not be dissapointed, I have a big 33% rehire rate. Thank you!

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

I have expertise in web-scraping using VBA. Client's satisfaction is my first priority and believe in long-term relationship with clients. Please communicate to discuss in details. Thank you..

Hey there :) This is Sourabh Gupta from New Delhi. I am an advanced Excel VBA programmer currently at the post of Forum Expert at www.excelforum.com. I checked the file and the code you posted, you are currently using browser automation using internet explorer which tends to be slow. However, we need not use the browser as the intermediary and directly send HTTP requests to the website and retrieve data which will be faster. I can also make these requests asynchronous which means that multiple requests can be sent at a time and then retrieved collectively which will make it insanely fast. However, I do not take guarantee if ebay will block the connection on receiving too many requests in a short span of time or anything like that, because such limits are not explicitly declared by ebay. So, yes I can speed it up tremendously but it is upto you to decide what option you want and how much requests you want to allow at a time. We can try with a fairly small number of requests like 10-20 at a time and see if that works fine for a few days and is not blocked by ebay. I look forward to a prompt and positive response from your side :) Regards Sourabh

I can help you whit this and make it fast and efficient. I have rich experience in scraping data via excel and VB. Please feel free to contact me. MySkills: • Data Management ..............................{Excel, Matlab} • Programming ......................................{Java, C#, VBA, PHP, HTML} • Web designing......................................{Wordpress} • 2D Graphic ...........................................{Photoshop, Macromedia Flash, ...} • 3D Graphic ...........................................{3dsMax, Blender, ...} • Engineering...........................................{AutoCad, Watergem, SewerCad, Flow3D, Elvis, ArcGIS, ...} • Researching .........................................{Green Energy, Solar cells, WaterManagement, ....} Services: ? Accuracy ? Customer satisfaction is my first "Priority" ? Time Commitment ? Availability Thanks, Shahin

Hi, How are you today? I'm perfect in Excel macro and vb. I'll finish your work in short time. And additionally I have expertise in Qt/PHP/Mysql/jQuery/CSS which can make your project perfectly. I can dedicate full time and I am online more than 10 hours a day. Looking forward to working with you. Thanks and regards

I am professional in web scraping and VBA. I can complete this project within a day using Xmlhttp request. by using xmlhttp request web scraping will work more faster then your code. one good thing of using this method is we don't required to open browser. please message me to discuss on your project. Thank You.

Hi! There's room for improvement indeed. It can be made to run in a so called(for MS Office Family automation) 'emulated multi-threading' manner. There's several points I need you to further touch on though: A) Version of MS Excel in use(I am assuming it's on Windows and not MAc, because it's using the Internet Explorer object)? B) The expected number of URLs this would be passing through, on average? C) Whether you require to be visually monitoring it while it's running, thus having to actually click on that button, or it can be for example tied with a Scheduled task on Task Manager? Kind Regards, Dobri

I can try to speed up the VBA code you share with me, if it doesn’t work i can try the Web scrap with R o Python

I can send you now a macro for that Worksheet which can do that job during 45seconds, and is not neccesary to open every url in IE. Regards Damian