Post a reply

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)


Topic review


It works fine, I needed to add "On Error Resume Next". Most of the classes are indeed hidden but work fine.

I was able to use the VBA code and send a file via SFTP using VB6.

Re: vb6 COM libary

I do not have VB6 to test this myself. But WinSCP .NET assembly works correctly in VBA, so I hope that it works in VB6 too.

vb6 COM libary

I installed the COM library and I can see it in the object browser in VB6, but many of the classes have nothing in them, like session. Further when I try to store & then retrieve session variables like in the demo the application crashes. I need to use VB6 I think for fixing a legacy program, so what I want to know is, is it possible to use the COM library in VB6? Am I missing something?

Here is some code. I know it's getting to the sub because the first MsgBox is firing.

Private session As WinSCPnet.session

Private Sub SendWinSCP()
MsgBox ("in SendWinSCP")
Set sessionOptions = New WinSCPnet.sessionOptions

sessionOptions.HostName = ""

MsgBox ("in SendWinSCP4 " & sessionOptions.HostName & "!")
' at this point it crashes since HostName can not be found.