0

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

There is an Excel report button, which will download an excel for the given Date Range, however, no matter what I set for the start or end date, the site has a maximum range of 7 days. What I'd like to do, is to download Excel sheets for a whole year, so in my imagination I'd like to have a VBA code which will step the Date Range by seven days and then download the Excel file for given period.

So far I haven't achieved that much, my code only looks like this:

Sub adatgyujto()

Dim appIE As Object
Set appIE = CreateObject("internetexplorer.application")

With appIE
    .Navigate "https://akk.hu/statisztika/hozamok-indexek-forgalmi-adatok/zero-kupon-hozamok"
    .Visible = True
End With

Do While appIE.Busy
    DoEvents
Loop

End Sub

I also tried to get the html code for the Date Range and download buttons, but they look strange to me.

The HTML code for the download button:

<span class="custom-menubar-menuitem-caption"><span class="v-icon Akk-Icons">?</span></span>
Improve this question
2
  • For your goal, a number of events must be triggered. As the IE is outdated, nobody will put any more energy into a solution. Here you can see how to work with events in IE: stackoverflow.com/questions/63294113/… It looks like browser automation is the way to go. This could be done with SeleniumBasic. I don't know how events can be handled there. Here you can see how SeleniumBasic can be made to work: stackoverflow.com/questions/57216623/… Commented Jun 5, 2024 at 19:45
  • I see, thank you! Yeah I figured IE wouldn't be the best to work with, however that is what I started with... Commented Jun 6, 2024 at 6:21
Related questions
651
How can I avoid using Select in Excel VBA?
606
Is there a way to crack the password on an Excel VBA Project?
0
Excel VBA searching for the range of dates and downloading the respective files
Load 4 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.