vba Excel VBA宏通过FTP上传下载
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/11403692/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Excel VBA macro upload and downloading through FTP
提问by user1476092
Please tell anyone how to do uploading and downloading csv files through ftp using Excel VBA macro.Can anyone please point me to any example or sample code .I want to copy that file to unix location.
请告诉任何人如何使用 Excel VBA 宏通过 ftp 上传和下载 csv 文件。任何人都可以向我指出任何示例或示例代码。我想将该文件复制到 unix 位置。
Regards,
问候，
Chaitu
柴图
回答by TastyWheat
If you have Microsoft Internet Transfer Controlas an available library this looks like the most elegant solution: http://officeone.mvps.org/vba/ftp_upload_file.html
如果您有Microsoft Internet Transfer Control作为可用库，这看起来是最优雅的解决方案：http: //officeone.mvps.org/vba/ftp_upload_file.html
Otherwise the most common solution involves executing shell commands: http://www.mrexcel.com/forum/showthread.php?471016-Import-an-FTP-file-into-Excel
否则，最常见的解决方案是执行 shell 命令：http://www.mrexcel.com/forum/showthread.php?471016-Import-an-FTP-file-into- Excel
