Read content of a XLSX or CSV file using VBA if that is stored on an FTP-server ? [Archive]

View Full Version : Read content of a XLSX or CSV file using VBA if that is stored on an FTP-server ?

pplanch

10-20-2021, 05:30 AM

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" ?