@Arun: Did you follow the instructions?
Before posting, please read how to report bug or request support effectively.
Bug reports without an attached log file are usually useless.
Dim mySessionOptions As New WinSCPnet.SessionOptions
With mySessionOptions ' Getting error here ActiveX component can't create object
FileTransferProgressevent/class, but can't seem to link the
FileTransferProgressinto VBA. Can anyone help me on this.
Private Sub download(ByRef mySession As Session)
' Setup session options
Dim mySessionOptions As New SessionOptions
.Protocol = Protocol_Webdav
.HostName = "abcd.com"
.PortNumber = 443
.UserName = "username"
.Password = "password"
.WebdavSecure = True
.TlsClientCertificatePath = "path_to_key"
NameFile = "name_of_file"
RemotePath = "name_of_file"
Dim transferResult As TransferOperationResult
Set transferResult = mySession.GetFiles(RemotePath, NameFile, False)
' Throw on any error
' Display results
Dim transfer As TransferEventArgs
For Each transfer In transferResult.Transfers