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

B

bobspero

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 = "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
 
A

abizer.kanchwala

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

Similar Threads

VBA Configure Proxy Server Settings of IE 0
How do I check that proxy setting are correct? 1
How Can I Click an un-name IE button via VBA 5
Outlook/Exchange 2003 over HTTPS delay with web proxy 1
Entourage 2004 cannot retrieve/send mail through a proxy server 4
Uploading Website 1
PUBLISHER 2003 ********PROBLEM HELP******** 1
"Could not find a web server on port 80" 8

Top