ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatic File Download using CuteFTP (https://www.excelbanter.com/excel-programming/365794-automatic-file-download-using-cuteftp.html)

RCL

Automatic File Download using CuteFTP
 
Hi: I have found how to do this, but there is some error in the
following code.
This code opens CuteFTP and executes a pre-recorded CuteFtpMacro that
downloads a file

Sub runcuteftp()
Dim RetVal
RetVal = Shell("C:\CuteFTP\cuteftppro.exe Macro=C:\Temp\MacroCute.vbs",
1)
End Sub

It seems to be some error before the "Macro" word, I think the is some
separator missing, because VBA Macro error says there is an invalid
path.

* Anybody knows how to correct this?

* Anybody knows how to close CuteFtp after downloading the file?

Thank you for your support and help !



All times are GMT +1. The time now is 02:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com