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....
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.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
Thanks and regards
KUmar