Entering password that refreshes data from FTP macro

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?

mate, this is very common question, a simple google search would have given you the answer

see code below

Please Login or Register  to view this content.