MsgBox 'Listing directory failed: ' & Err. ListDirectory ( '/home/user/' ) ' Do some stuff with directory listingĮnd Sub Dim mySession As New Session ' Enable custom error handling On Error Resume Next ' Now, with custom error handling enabled before calling the ListDirectory subprocedure, ' any statement in the subprocedure terminates the subprocedure (but not the whole execution) Sub ListDirectory ( ByRef mySession As Session ) ' Setup session optionsĭim directoryInfo As RemoteDirectoryInfo Set directoryInfo = session. This approach is also recommended to ensure that Session.Dispose is called even in case of error. If you do not want to test for errors after every statement, you need to group the statements you want to guard into a subprocedure and enable custom error handling before calling/entering the subprocedure. Description EndĮnd If ' Restore default error handling On Error GoTo 0 ' Now, with default error handling restored, ' macro aborts, if a reading remote directory fails Dim directoryInfo As RemoteDirectoryInfo Set directoryInfo = session. ' Enable custom error handling On Error Resume Next ' Now, with custom error handling enabled, ' macro does not abort, when opening a session fails You can revert to default error handling (aborting the macro) using On Error GoTo 0. Then you need to query Err.Number after every statement to test for errors. Use On Error Resume Next to disable default error handling. In case you need to use custom error handling, instead of interrupting a VB macro (the default behavior), use On Error statement. VBA does not support catching exceptions, what is a common way of handling errors in examples for most other languages. Private WithEvents mySession As Session Public Sub Example ( ) Set mySession = New Session ' Open connectionĮnd Sub Private Sub mySession_FileTransferred ( ByVal sender, ByVal e As TransferEventArgs )

sender and e) for every event you need to handle.įollowing example shows how to handle a Session.FileTransferred event. Define private function (method) with name _ and two arguments (e.g.Use WithEvents keyword, when declaring the private variable.Declare private variable in your class module referring to Session class.Implement your interactions with WinSCP.The Session class exposes several events.

Members of enumerations are represented as constants with name like _, e.g. There are some less known techniques that you may need to use, which are described in following sections. In Microsoft Visual Basic editor, go to Tools > References, check reference to WinSCP scripting interface. NET assembly from VBA (Microsoft Office, including Excel, Word and Access) as any other COM library. NET assembly and register it for COM.Ĭheck if your installation of Microsoft Office is 32-bit or 64-bit and register the assembly accordingly. Advertisement Installing and Registering for COMįirst, you need to install the WinSCP.

Find which office 32bit or 64bit vb.net