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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.