IE Automation through Excel for downloading a CSV File

[Kumarcoolz]

i am trying to automate a task of going to http://ad.easa.europa.eu/ and download a CSV file from the 'Export list as...' tab (refer picture in attachment for the exact link boxed out in red). i have been googleing and i have achieved the following code to open the website on IE so far....

Sub Test()
    
    Dim cURL As String
    Dim IE As InternetExplorer
    
    cURL = "http://ad.easa.europa.eu/"
    Set IE = New InternetExplorer
    
    IE.Visible = True
    IE.Navigate cURL
    Do While IE.ReadyState <> READYSTATE_COMPLETE Or IE.Busy: DoEvents: Loop
    
End Sub

i tried to trigger 'click' but i am unable to find the right method to do it. any help or suggestion onto this would be very gr8...My ultimate aim is to download the CSV file to my desired location, get all the details of the CSV file into the excel sheet which executes this Macro.

Thanks and regards
KUmar