Modifying IE settings using Excel VBA 2

[gokerry]

Hi there,

Some of the Excel templates i have developed requires a modification in IE settings,
- Under Internet Explorer properties \ Advance Tab \ uncheck "Use HTTP 1.1 through proxy connection"

Any idea, how to perform the above uncheck procedure programmatically.

Will really appreciate any idea or comments.

Thanks

S.

 

[shetlandbob]

initial thoughts is you'd have to edit the registry?

 

[gokerry]

Good thought to get started. in the registry settings, there are three values(apart from others),

HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings

CheckedValue
UncheckedValue
ValueName

But, when I change the check/unchecked manually to see the effect and settings for that state, it does not change at all. ?? any clue ?

what to set now ??
"ProxyHttp1.1"=dword:00000000 ..........??? or something else ??

Thanks,
S.

 

[gokerry]

sorry, the place I looked at was (ignore the above one),

HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\AdvanceOptions\HTTP\Proxy

 

[TonyJollans]

Hi gokerry,

I wouldn't advocate changing the registry unless you are sure what you're doing but I just tested and on my machine and:
HKCU\Software\Microsoft\Windows\CurrentVersion\Internet Settings\ProxyHttp1.1
seems to change between 0x00000000 and 0x00000001

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[

 

[gokerry]

For those who are interested, this is the solution that worked for me. (may not be the best one, but afterall result is what counts. Enhancements are welcomed).

in blank notepad enter this:

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Windows\CurrentVersion\Internet Settings]
"ProxyHttp1.1"=dword:00000000


And, save the notepad as <FileName>.reg
"ProxyHttp1.1"=dword:00000000 will uncheck the proxy
"ProxyHttp1.1"=dword:00000001 will check the proxy HTTP1.1

Thanks shetlandbob for your precious suggestion. You deserve credit for that, though have no idea what's the procedure, as I'm new here and my first posting on any of the websites.

Thanks
S.

 

[gokerry]

TonyJollans,

show your post after I posted the solution on the net, but still will give you credit for sharing your precious time and right answer.

ONE QUESTION TO THOSE WHO LIKES TO GET INTO DEEPER: Continuation of the thread --

how do you change this setting via VBA. I have some codes that i used in past for registering Add-ins -- OPTION --. but this require DWORD SETTING. got there as well. VBA code writes to registry name "ProxyHttp1.1" too, but I'm not able to set the right value for the same. it writes 0 (as string) or gives error in value property.

Thanks,
S.

 

[PHV]

Have a look here:

http://msdn.microsoft.com/library/en-us/wmisdk/wmi/stdregprov.asp

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886