ExecWB
 

Hello:

What's the code: "ExecWB"
HOw does this work?

ExecWB
 

It's nothing build-in. Select it and press Shift-F2 to go to the
definition, if it has one.

--
Jim
"art" wrote in message
...
| Hello:
|
| What's the code: "ExecWB"
| HOw does this work?

ExecWB
 

It has no defention. So what does it mean. what does it do. If there is no
definition, then it is prob. not something built in.

"Jim Rech" wrote:

It's nothing build-in. Select it and press Shift-F2 to go to the
definition, if it has one.

--
Jim
"art" wrote in message
...
| Hello:
|
| What's the code: "ExecWB"
| HOw does this work?

ExecWB
 

It looks like it's some kind of call to a webbrowser (at least there were a few
hits on google for that).

When do you see it?

What problem does it cause?



art wrote:

It has no defention. So what does it mean. what does it do. If there is no
definition, then it is prob. not something built in.

"Jim Rech" wrote:

It's nothing build-in. Select it and press Shift-F2 to go to the
definition, if it has one.

--
Jim
"art" wrote in message
...
| Hello:
|
| What's the code: "ExecWB"
| HOw does this work?



--

Dave Peterson

ExecWB
 

It's not an error. Just I needed a macro to get import information from the
web based on the info from a cell in excel. Someone gave me the following
VBA, and was wondering when it comes to select the web page it uses this
code. the VBA is as followes:

Sub Button1_Click()
Set ie = CreateObject("InternetExplorer.Application")

With ie
.Visible = True
.Navigate "http://www.google.com/"
.Top = 50
.Left = 530
.Height = 400
.Width = 400

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop

' Make the desired selections on the Login web page and click the submit
Button
Set ipf = ie.Document.all.Item("q")
ipf.Value = Range("A1")

ie.Document.all.Item("btnG").Click

' Loop until the page is fully loaded
Do Until Not ie.Busy And ie.ReadyState = 4
DoEvents
Loop


' Copy the entire web page and then paste it as text into the Worksheet
ie.ExecWB 17, 2
ie.ExecWB 12, 0

Range("A3").Select
ActiveSheet.PasteSpecial Format:="Text", Link:=False,
DisplayAsIcon:=False
Range("A3").Select

End With

ie.Quit

I would like to rather select just part of the web page and this selects the
whole page. Any help?

"Dave Peterson" wrote:

It looks like it's some kind of call to a webbrowser (at least there were a few
hits on google for that).

When do you see it?

What problem does it cause?



art wrote:

It has no defention. So what does it mean. what does it do. If there is no
definition, then it is prob. not something built in.

"Jim Rech" wrote:

It's nothing build-in. Select it and press Shift-F2 to go to the
definition, if it has one.

--
Jim
"art" wrote in message
...
| Hello:
|
| What's the code: "ExecWB"
| HOw does this work?



--

Dave Peterson

ExecWB
 

Set ie = CreateObject("InternetExplorer.Application")
Here, creating OLE link, as wrote, with IE.
* * * * ie.ExecWB 17, 2
Here, called IE method.

RTF... Ouch! MSDN

http://msdn.microsoft.com/en-us/libr...43(VS.85).aspx

ExecWB
 

Can you please explain yourself? I dont understand what you are saying.

Thanks.

"NOPIK" wrote:


Set ie = CreateObject("InternetExplorer.Application")
Here, creating OLE link, as wrote, with IE.
ie.ExecWB 17, 2
Here, called IE method.

RTF... Ouch! MSDN

http://msdn.microsoft.com/en-us/libr...43(VS.85).aspx