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
Bookmarks