Download Data from Web Site

I have to download sales spreadsheets from a Costco Web Site everyday but is become a very tedious task. I know I could create a macro in Excel and download the data with a web query. The issue here is that I have to sign in to the website everytime and also that there is a certificate that Costco forces you to use for security reasons which will run after you sign in and will popo up a window that you have to close by clicking the OK button.
I want to be able to click a button in excel that will transfer the sales data into an excel sheet without me having to type in my username and password everytime and clicking the "ok" to the certificate window that appears every time.

Would anyone please help me with this?

Thanks

Moroformat

You could use IE automation and the MSHTML library to handle the username and password login, however both would have to be stored in your VBA code or the workbook, so presenting a security risk. MSHTML manipulation might be able to prevent the pop-up window appearing, if not SendKeys might work. Then use URLDownloadToFile to download the spreadsheet files. Search Google etc. for the terms mentioned.