Thanks for your suggestion.

I tried "URLDownloadToFile", but it doesn't give me the desired result. It downloads the login page and stores it to the sheet.

Is there any other way ?

If I use *myHTMLElement.Click* instead of *Workbook.Open* then I get the download popup window from Internet explorer and clicking on save gives me the list I need but I need code to to all the work.

Any help would be great.