little help
On Jan 27, 11:41*am, bluburter wrote:
On 27 Sty, 15:22, ron wrote:
The code I posted above
* * ie.ExecWB 17, 2
* * ie.ExecWB 12, 0
works for me on the web page we're discussing...Ron
Hi Ron,
I tried to use such a code:
ie.ExecWB 17, 2
ie.ExecWB 12, 0
Range("E3").Select
ActiveSheet.PasteSpecial Format:="Tekst", link:=False, DisplayAsIcon:=
_
* * False
as a result I got in excel only:
"EDP.No:"
"Loading...."
Coud you please let me know what is your excel ver ?
I don't have any idear why it does not work for me....
Kris
I looked at the web page again and noticed that the information of
interest is in a frame called "mainfrm". Once you put the focus on
this frame by manually clicking in that area of the webpage, then you
can capture the source code with all of the information that is of
interest by using
zz = ie.document.frames("mainfrm").document.DocumentEle ment.innerhtml
I haven't figured out how to programmatically select the frame...Ron
|