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



I spent the better part of the morning looking through MSDN docs, I want toopen 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 = ""
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"
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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question