VBA example won't work :: Support Forum

Marrob
Joined:: 2025-02-04
Posts:: 3
Location:: Italy

VBA example won't work

2025-02-04 17:31

It looks as if the sessionOptions class is empty?!?!
the WITH fails:

The class does not support the expected interface

area

+ : provaFTP : : provaFTP/provaFTP
- : mySession : : Session/Session

- : mySessionOptions : : SessionOptions/SessionOptions
: : <Nessuna variabile> :
: myTransferOptions : Nothing : TransferOptions
: transferResult : Nothing : TransferOperationResult
: transfer : Nothing : TransferEventArgs
code:

Private Sub Upload(ByRef mySession As Session)
 
    ' Imposta le opzioni di sessione
    Dim mySessionOptions As SessionOptions
    Set mySessionOptions = New SessionOptions
    With mySessionOptions
    .Protocol = "Protocol.Sftp"
    .HostName =

Reply with quote

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

Re: VBA example won't work

2025-02-06

The VBA enumeration syntax is <type>_<member>:

    .Protocol = Protocol_Sftp

See https://winscp.net/eng/docs/library_vb#enums

Reply with quote

Marrob
Joined:: 2025-02-04
Posts:: 3
Location:: Italy

Re: VBA example won't work

2025-02-06 15:58

Thanks a lot, but without " as in the example I have a

Compilation error : impossibile trovare il metodo o il membro dei dati

Do you have working examples?
When do you inspect the SessionOption object what do you see?

Regards

Reply with quote

martin◆ Site Admin

Re: VBA example won't work

2025-02-08

All the examples on our site are working.
I've even tested your code. After the above correction, it is WORKING in Excel.
How exactly are you using/running the VBA code? Post some screenshots.

Reply with quote