I am getting this above-mentioned error on running. The purpose of this code is to take values from excel sheet and put two values from sheet into website then extract results from web in a sheet.
here is the code.
it shows error on this line Do While ie.Busy Or ie.readyState <> 4
i also used READYSTATE_COMPLETE it did not work too.
Sub WebAutomation()

I tried the methods found on the internet. However, they did it either with “power query” or vba. “Power query” doesn’t work for me. Those made with VBA do not fit this website. How should I proceed?

As the title suggests I’d like to download multiple Excel’s from the following site:
https://akk.hu/statistics/yields-indices-market-turnover/zero-coupon-yields

I’m trying to do a simple macro with a site that beautify code,

I’m trying to get the class name of the div element that contains the information the calling areas between many div elements in the url. Since the div that contains the calling area information has USA states names, I’m using one state name as anchor to identify the div