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 |
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