View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bobspero@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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