Hi. I have a macro that simply refreshes data from a FTP server using the command ActiveWorkbook.RefreshAll however it prompts for the FTP password every time the work book is opened. How can I enter the password in the macro so it refreshes automatically without the need to enter anything? Also can I add a specific time so the macro runs automatically?