SFTP? Can someone explain how this works??

[scm160]

Hi Guys,

Can someone explain how this code works??? I'm in the process of reverse engineering code for a project I'm working on. Some of the proprietary links/users have been deliberately changed.

Just need to understand what's going on here and why exactly a user would use File Transfer Protocol. There's more procedures to this module but I took out a snippet just for starters.

Public Sub SFTPGet(fname As String)
    Const cstrSftp As String = """mylink.com/pscp.exe"""
    Dim strCommand As String
    Dim pUser As String
    Dim pKey As String
    Dim pHost As String
    Dim pFile As String
    Dim pLocalPath As String

    pUser = "user1"
    pKey = """" & BILLING_FOLDER & "some_private.ppk"""
    pFile = "someplace/data" & fname
    pLocalPath = """" & sInputFileFolder & "."""

    strCommand = cstrSftp & " -sftp -l " & pUser & " -i " & pKey & " " & pFile & " " & pLocalPath

    Shell strCommand
End Sub

 

[mole999]

basically if you look at StrCommand you can see each element from above, being assembled together with the & sign, and then the string is used in the shell command so (roughly)
strCommand = cstrSftp & " -sftp -l " & pUser & " -i " & pKey & " " & pFile & " " & pLocalPath
strCommand = mylink.com/pscp.exe -sftp -l user1 -i " BILLING_FOLDER & "some_private.ppk someplace/data fname sInputFileFolder

 

[scm160]

Hi Mole - sorry didn't get back to you sooner. Appreciate your help on this!