Post a reply

Before posting, please read how to report bug or request support effectively.

Bug reports without an attached log file are usually useless.

Options
Add an Attachment

If you do not want to add an Attachment to your Post, please leave the Fields blank.

(maximum 10 MB; please compress large files; only common media, archive, text and programming file formats are allowed)

Options

Topic review

utb2b

Re: automation error VBA

martin wrote:

On what line does it throw?
Did you use a different version of the assembly on that machine before? It you did, did you unregister it?


Thanks for your response.

With SFTPSessionOptions

in the above line it pops up Automation error.

Actually I was using winscp 5.1.7 . Yesterday, we tried to uninstall winscp 5.1.7 and unregister dll and tlb. we tried to install a winscp 5.5 and registered winscpnet.dll successfully. manual interface of winscp is working on that machine. But VBA macro pops up the same error message on the same line.

With SFTPSessionOptions .

Thanks in advance.
martin

Re: automation error VBA

On what line does it throw?
Did you use a different version of the assembly on that machine before? It you did, did you unregister it?
utb2b

automation error VBA

Hi Support,

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

With SFTPSessionOptions
.Protocol = Protocol_Sftp
.HostName = txtHN.value
.UserName = txtUN.value
.password = txtPWD.value
.portnumber = txtPort.Value
.SshHostKeyFingerprint = txtHostkey.value
End With


SFTPSession.Open SFTPSessionOptions

Thanks in advance for your help and support.

Thanks,
utb2b