I need to be able to pick up data from a CSV, a TXT or an XLSX file stored on an FTP-server. Any tips on how to do that ? Is it as simple as replacing the typical C-drive path name of a file with the URL in a statement similar to Open ThisWorkbook.Path & "\TextFile.txt" ?