Forum » .NET assembly / COM library »

Add Raw Setting is VBA

Franklin321
Joined:: 2015-08-11
Posts:: 3
Location:: Cape Town

Add Raw Setting is VBA

2015-08-11 13:21

Hi,

Any help would be of great assistance.

How do I add ProxyHost, ProxyPort, ProxyUsername, ProxyPassword to SessionOptions in VBA?

Regards,
Franklin

Reply with quote

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

Re: Add Raw Setting is VBA

2015-08-14

I cannot try right now, but this should do:

Dim mySessionOptions As New SessionOptions
With mySessionOptions
    .Protocol = Protocol_Sftp
    .HostName = "example.com"
    .UserName = "user"
    ...
 
    .AddRawSettings "ProxyHost", "proxy"
    .AddRawSettings "ProxyPort", "90"
    ...
End With

Reply with quote

Franklin321

Re: Add Raw Setting is VBA

2015-08-14 14:29

Thanks for the feedback.

I tried your suggested implementation but it produces a syntax error.

Reply with quote

martin◆ Site Admin

Re: Add Raw Setting is VBA

2015-08-23

OK, the brackets should not be there. See corrected example above.

Reply with quote

Franklin321

Re: Add Raw Setting is VBA

2015-08-26 08:46

Thanks alot @martin. It worked after adding a couple of other rawsettings for the connection.

Reply with quote

Cordero Guest

Re: Add Raw Setting is VBA

2022-01-20 16:48

How was this proxy issue resolved using VBA?
Could you give an example?

Reply with quote

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

Re: Add Raw Setting is VBA

2022-01-24

@Cordero: The example is above.

Also WinSCP GUI can generate a VB.NET code template for you:
https://winscp.net/eng/docs/ui_generateurl#code

Reply with quote

You can post new topics in this forum