I have got simple VBA program which help us to download files from SFTP server. It's working perfectly in mostly in all machines.
when I try to use the same excel in particular machine it throws automation error.
OS: Windows 7
WINSCP version: winSCP 5.1.7
we tried to uninstall winscp and unregister the tlb and dll. we try to install again and getting same error Automation Error. (object variable is not set.
below is the code.
Dim SFTPSession As New session
Dim SFTPSessionOptions As New sessionOptions
.Protocol = Protocol_Sftp
.HostName = txtHN.value
.UserName = txtUN.value
.password = txtPWD.value
.portnumber = txtPort.Value
.SshHostKeyFingerprint = txtHostkey.value
Thanks in advance for your help and support.