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

Author Message
[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:
Sub SessionOpen()
    If Not mySession Is Nothing Then
    End If
    Set mySession = New WinSCPnet.Session
    On Error GoTo er
    mySession.Open GetSessionOptions
    GoTo finish
    handleError True
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
[View user's profile]
Site Admin
Joined: 2002-12-10
Posts: 26890
Location: Prague, Czechia
Are you getting the error on Set mySession = New WinSCPnet.Session ?

You can post new topics in this forum


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!


About donations

$9   $19   $49   $99

About donations


WinSCP Privacy Policy

WinSCP License