IE automation, Frames content reading problem, excel 2003 and 2007

P

Piotr Zaniewski

Hi,

I'm trying to read information from web site with frames. I have
developed following code which allows me to connect to the site, pick
desired frame and later I cannot read frame site contents, an error
occures:

Dim doc As HTMLDocument
Dim wbframe As HTMLFrameElement
Dim wbtable As HTMLTable
Dim oIE As SHDocVw.InternetExplorer


Set doc = oIE.document.frames(0).document ' here I get
error: Access is denied
Set wbtable = doc.getElementsByTagName("table")(0)
Debug.Print doc.body.innerHTML

Thanks in advance

Piotr
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top