Question for WINSCP software and code for excel application currentlyusing FTP for uploading downloa

[Yuvraj]

Hi All,

I am using

1. Open = InternetOpen(FTP_AGENT, INTERNET_OPEN_TYPE_PRECONFIG,
vbNullString, vbNullString, 0) 'Return a handle/Open an internet
connection

and other functionality like

2. public Function upload(ByVal pSourceFile As String, ByVal
pTargetFile As String) As Boolean

upload = FtpPutFile(zlhwndConnection, pSourceFile, pTargetFile,
FTP_TRANSFER_TYPE_BINARY, 0)

End Function
************************************
3. Public Function download(ByVal pSourceFile As String, ByVal
pTargetFile As String) As Boolean

On Error GoTo eofn

download = FtpGetFile(zlhwndConnection, pSourceFile, pTargetFile,
False, 0, FTP_TRANSFER_TYPE_BINARY Or INTERNET_FLAG_RELOAD, 0)

eofn:

End Function

And lot of other functionalities to upload and download the files from
the Centralized server.

I am using the WINSCP software and the protocol used is FTP.

I just wanted to know if I want to use SFTP instead of the FTP.

do I need to change the excel application architecture which is
currently running.

How to go about changing the Protocol.

Any links which will be helpful.

Will my functionalities of the excel application and architecture
needs changing or will it be a big change to change the uploading and
downloading mechanism.

Please guide,

Yuvaraj