Thread: little help
View Single Post
  #14   Report Post  
Posted to microsoft.public.excel.programming
ron ron is offline
external usenet poster
 
Posts: 118
Default 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