Select the or .NET Assembly tab to see a ready-to-use template for your specific connection. Using VBA to run WinSCP script - excel - Stack Overflow
Automating file downloads from an SFTP server directly into Excel can significantly streamline your data workflows. Using is one of the most reliable ways to achieve this, offering both a simple "command-line" approach and a more robust "API-driven" method. Prerequisites excel vba winscp download
: You will need the host key fingerprint to securely connect to the SFTP server. You can find this by manually connecting once via the WinSCP GUI. Method 1: The Simple Command-Line Approach Select the or
Sub DownloadFilesWithWinSCP() Dim mySession As New Session Dim mySessionOptions As New SessionOptions ' Setup connection details With mySessionOptions .Protocol = Protocol_Sftp .HostName = "example.com" .UserName = "user" .Password = "mypassword" .SshHostKeyFingerprint = "ssh-rsa 2048 xxxxxxxxxxx..." End With On Error GoTo ErrorHandler mySession.Open mySessionOptions ' Download files Dim transferResult As TransferOperationResult Set transferResult = mySession.GetFiles("/remote/path/*", "C:\local\path\", False) ' Check for success transferResult.Check MsgBox "Download complete!" mySession.Dispose Exit Sub ErrorHandler: MsgBox "Error: " & Err.Description mySession.Dispose End Sub Use code with caution. Pro Tip: Generate Code Automatically Prerequisites : You will need the host key
In Excel, go to and check WinSCP scripting interface .NET wrapper . 2. VBA Code for SFTP Download