Topic "Create new WinSCPnet.Session Object in VBA fails"

Author Message
hans.wirz@xmv.ch
[View user's profile]

Joined: 2015-12-22
Posts: 1
Hi I'd like to use your .Net wrapper to do some FTP-Stuff within MS Access 2010 with VBA.
As I try to create a new Session-Objekt, I allways get an Automation-Error ([-2146233321] Automatisierungsfehler).

I did download the latest Assembly and registered as written in your Website.
In Access the TLB is visible after registration and 'compiling' the VBA-Code went without errors

The Code which fails looks like this:
Code:

Sub SessionOpen()
    If Not mySession Is Nothing Then
        mySession.Dispose
    End If
    Set mySession = New WinSCPnet.Session
   
    On Error GoTo er
   
    mySession.Open GetSessionOptions
   
    GoTo finish
er:
    handleError True
   
finish:
       
End Sub



Is there something else I've probably missed to get the Wrapper running?
I use Windows 10 on a 64bit Dell-Maschine.

I appreciate your help
Kind regards
Hans
martin
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 24552
Location: Prague, Czechia
Are you getting the error on Set mySession = New WinSCPnet.Session ?
Advertisements

You can post new topics in this forum






Search Site

What is WinSCP?

It is award-winning SFTP client, SCP client, FTPS client and FTP client integrated into one software program for file transfer to FTP server or secure SFTP server. [More]

And it's free!

Donate

About donations

$9   $19   $49   $99

About donations

Recommend

WinSCP Privacy Policy

WinSCP License