Loading Internet Explorer and setting window location.

[petrillo]

I have created an automatic google search for a list of items. I have a form that resides in the upper left hand corner of the screen.

I would like to have the Internet Explorer pop-up load in the bottom right if possible, or at least below the 250 height x 300 width form. The goal is to prevent employees from moving the IE window each time a new search pops up.

Additionally, is it possible to use the code to add a new tab for searching, rather than a completely new window?

Here is the code I use -


Set browser = CreateObject("InternetExplorer.Application")
browser.Navigate (SearchURL)
browser.StatusBar = False
browser.Toolbar = False
browser.Visible = True
browser.Resizable = True
browser.AddressBar = True



I went off a whim and tried "browser.Location" but couldn't get that to work.

Thanks in advance!

John

 

[AlphaFrog]

<font face=Courier New>    <SPAN style="color:#00007F">Set</SPAN> browser = CreateObject("InternetExplorer.Application")<br>    <SPAN style="color:#00007F">With</SPAN> browser<br>        .Navigate ("http://www.cnn.com/")<br>        .StatusBar = <SPAN style="color:#00007F">False</SPAN><br>        .Toolbar = <SPAN style="color:#00007F">False</SPAN><br>        .Visible = <SPAN style="color:#00007F">True</SPAN><br>        .Resizable = <SPAN style="color:#00007F">True</SPAN><br>        .AddressBar = <SPAN style="color:#00007F">True</SPAN><br><br>    <SPAN style="color:#007F00">' Position</SPAN><br>        .Width = 500<br>        .Height = 500<br>        .Top = 500<br>        .Left = 500<br>        <br>    <SPAN style="color:#007F00">'Open in new Tab (u need to pass the value 2048)</SPAN><br>        .Navigate2 "http://www.msn.com/", Flags:=navOpenNewForegroundTab<br>        <br>    <SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">With</SPAN></FONT>


You may find these links helpful
http://vba-corner.livejournal.com/4623.html
http://msdn.microsoft.com/en-us/library/aa752043(v=VS.85).aspx

 

[petrillo]

Perfect!

The tab issue doesn't work, but I can do without it. Might be the version of IE (8).

Thanks for the help!