Re: VBA example won't work
Grazieeeeeeeeeeeeee!!!!!!!!!!!!!!!!!!!!!
- Marrob
Post a reply
Topic review
- martin
Re: VBA example won't work
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.
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.
- Marrob
Re: VBA example won't work
Thanks a lot, but without
Do you have working examples?
When do you inspect the
Regards
" 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
- martin
Re: VBA example won't work
The VBA enumeration syntax is
See https://winscp.net/eng/docs/library_vb#enums
<type>_<member>:
.Protocol = Protocol_SftpSee https://winscp.net/eng/docs/library_vb#enums
- Marrob
VBA example won't work
It looks as if the
the
area
+ : provaFTP : : provaFTP/provaFTP
- : mySession : : Session/Session
- : mySessionOptions : : SessionOptions/SessionOptions
: : <Nessuna variabile> :
: myTransferOptions : Nothing : TransferOptions
: transferResult : Nothing : TransferOperationResult
: transfer : Nothing : TransferEventArgs
code:
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 =