Create new WinSCPnet.Session Object in VBA fails :: Support Forum

hans.wirz@xmv.ch
Joined:: 2015-12-22
Posts:: 2

Create new WinSCPnet.Session Object in VBA fails

2015-12-22 01:35

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
        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

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,442
Location:: Prague, Czechia

Re: Create new WinSCPnet.Session Object in VBA fails

2015-12-23

Are you getting the error on Set mySession = New WinSCPnet.Session ?

Reply with quote

Guest

Re: Create new WinSCPnet.Session Object in VBA fails

2018-01-07 00:18

martin wrote:

Are you getting the error on Set mySession = New WinSCPnet.Session ?

Sorry for not beeng back earlier ;-)
Yes, the error appears exactly on that line

Reply with quote

martin◆ Site Admin
Joined:: 2002-12-10
Posts:: 41,442
Location:: Prague, Czechia

Re: Create new WinSCPnet.Session Object in VBA fails

2018-01-08

Are you able to instantiate the object in PowerShell?
https://winscp.net/eng/docs/library_powershell

If you are, are you able to instantiate the object in VB script?
https://winscp.net/eng/docs/library_com_wsh

Reply with quote

Create new WinSCPnet.Session Object in VBA fails