Code to SFTP

[jstevens]

Is it possible to save a file directly to a SFTP site?

I have the name of the SFTP, UserID, Password, Port and Path.

Thanks,
John

[HansV]

No, you have to save the workbook to disk first and transfer that.

[jstevens]

Hans,

Okay if the file is saved, what would the transfer code look like?

Regards,
John

[HansV]

I don''t know anything about sftp, but I guess you'd have to find out what command line you'd need, then use

Shell "sftp ..."

where "sftp ..." is the command line. If you want to get fancy, use ShellWait (from API: Shell and Wait) - it will wait until the transfer is completed.

[cecil]

I have not done SFTP, but for FTP I always used the Shell-N-Wait that Hans pointed to. I would always pick up the return code to verify success or to notify if failure.