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

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.