We are working on Excel code to make structured Contact records.
It would be useful to open a WebBrowser window for source text

I have not yet found suitable sample text for VBA and VBE under XP 2003.

One way might be to invoke a New Web Query - is there any code to do that?

Ross Wilcock

What does "open a WebBrowser window for source text" mean?

Do you need a web browser to view html documents, or are you asking about
automating IE to perform some task?

Tim

--
Tim Williams
Palo Alto, CA


"Ross Wilcock" wrote in message
...
We are working on Excel code to make structured Contact records.
It would be useful to open a WebBrowser window for source text

I have not yet found suitable sample text for VBA and VBE under XP 2003.

One way might be to invoke a New Web Query - is there any code to do that?

Ross Wilcock

Thanks Tim for your reply. Sorry - busy learning!
I simplified the task to just open IExplorer by clicking a button. I
haven't found how to call IE from a macro yet.
Thanks for your interest.
Ross



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

This will do what you want to start with....

Post again if you have more advanced requirements!

Tim.

Sub CreateAndLoad()

dim IE
Set IE = CreateObject("InternetExplorer*.Application")
IE.Visible = True
IE.navigate "http://www.yahoo.com"

'wait while the page loads (optional)
Do While Not IE.readyState = READYSTATE_COMPLETE
Loop

End Sub

"Ross Wilcock" wrote in message
...

Thanks Tim for your reply. Sorry - busy learning!
I simplified the task to just open IExplorer by clicking a button.
I
haven't found how to call IE from a macro yet.
Thanks for your interest.
Ross



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!