Internet explorer window set as child window in Excel?

[muriealdurian]

ok... so here is something i'd love to do, but i'm not sure if it is possible.

i've been researching the whole "taking control of IE via vba" thing for a while, and i've got a spreadsheet that works well for what i want to do.

now... here is the serious question.
- Is it possible to have Excel capture an IE window and set it as an internal child window?

the reason why i ask is because when Excel opens up IE to do what it needs to do, it opens as a separate task (obviously) and i'd like to be able to work through another instance of IE without it taking focus or possibly mix up data that might be exchanging. i think it would strenghthen the design and layout of my spreadsheet.

any ideas?

 

[muriealdurian]

hmm... lets try again.

anyone?

 

[John_w]

Putting the WebBrowser control in a userform might give what you want.

 

[muriealdurian]

interesting...

i never considered doing that...

i'm actually fairly novice when it comes to actual webbrowser controls.

any suggestions before i just tear it apart and figure it out?

thanks!

 

[muriealdurian]

John w,

thanks so much for pointing me towards the web browser. I was not aware of its availability... i've been utilizing IE externally, now i've got everything internally.

however, i'm still having trouble trying to figure out how to get the webbrowser to load onto a Userform. Could you kindly offer up some information on that?

Thanks so much for your help!

 

[John_w]

You put the WebBrowser control on a userform by dragging/selecting it from the Toolbox, just like any other control (TextBox, CommandButton, etc.). To get the WebBrowser control onto the Toolbox, right-click the Controls tab on the Toolbox and select Additional Controls and select Microsoft Web Browser. Google it if you're still having problems.

 

[muriealdurian]

wow... i just found it.

it was seriously that easy? O_O

i was wondering why the userform controls were so limited.

i'm self taught, so i'm sure there are plenty of things i'm not aware of or have missed by now.

thanks again for your help!