Hi. I would like to import a excel file that is stored on a ftp drive into a workbook, into sheet 1. I would like it to update the imported sheet when i refresh the sheet or run a refresh macro. I have tried using the Data from other sources with no avail. Thanks.