ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting IE Object Properties w/ VBA - Proxy Server & Port (https://www.excelbanter.com/excel-programming/448984-setting-ie-object-properties-w-vba-proxy-server-port.html)

[email protected]

Setting IE Object Properties w/ VBA - Proxy Server & Port
 

I spent the better part of the morning looking through MSDN docs, I want to open an web page through a proxy server from my excel sheet. The below works fine but I can not find the proxy settings. Are the proxy settings available??? I know that in the "WinHttp.WinHttpRequest.5.1") you can set the proxy and port but what about when opening the web page?
Any help would be great thanks!



Set objIE = CreateObject("InternetExplorer.Application")
WebSite = "www.google.com"
With objIE
.Visible = True
.navigate WebSite
'.proxy = "my Proxy" error here
'.port ="myport" error here
Set Element = .document.getElementsByName("q")
Element.Item(0).Value = "Hello world"
.document.forms(0).submit
'.quit
End With

[email protected]

Setting IE Object Properties w/ VBA - Proxy Server & Port
 

Looking out solution for the similar query..


XMLHTTP is the another method through which you can set proxy using VBA; however opening IE through VBA and setting proxy is a real task.


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com