Add Raw Setting is VBA

Advertisement

Franklin321
Joined:
Posts:
3
Location:
Cape Town

Add Raw Setting is VBA

Hi,

Any help would be of great assistance.

How to i add proxyHost, ProxyPort, ProxyUsername, ProxyPassword to SessionOptions in VBA

Regards,
Franklin

Reply with quote

Advertisement

martin
Site Admin
martin avatar
Joined:
Posts:
29,266
Location:
Prague, Czechia

Re: Add Raw Setting is VBA

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
Joined:
Posts:
3
Location:
Cape Town

Re: Add Raw Setting is VBA

Thanks for the feedback.

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

Reply with quote

martin
Site Admin
martin avatar
Joined:
Posts:
29,266
Location:
Prague, Czechia

Re: Add Raw Setting is VBA

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

Reply with quote

Franklin321
Joined:
Posts:
3
Location:
Cape Town

Re: Add Raw Setting is VBA

martin wrote:

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

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

Reply with quote

Advertisement

You can post new topics in this forum