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.