Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Frame Text Access Using Internet Explorer Object in Excel

Status
Not open for further replies.
almostfrugal

almostfrugal

Programmer
Apr 30, 2003
8
0
0
US
I have programmed an Excel VBA macro which creates an Internet Explorer object (objInternetExplorer) and then navigates to a webpage which contains frames. I want to grab text from inside one of the frames. I've tried:

Code: 
strText = objInternetExplorer.Document.Body.InnerText

and all I get is an empty string. Surely there is a way to navigate the DOM to get to the text I want, but I just can't find it. Thanks.
 
Status
Not open for further replies.

Similar threads

Andrzejek
  • Question
Outlook Template replace text 2
Replies
13
Views
937
Andrzejek
Andrzejek
Andrzejek
  • Question
Outlook VBA - Trust access
Replies
3
Views
229
hermanlaksko
hermanlaksko
morechocolate
  • Question
run-tune error 3704 operation is not allowed when the object is codes: I don't think so.
Replies
7
Views
309
morechocolate
morechocolate
linuxguyEastCoast
  • Locked
  • Question
export text from non-public docx, pptx, pdf
Replies
0
Views
119
linuxguyEastCoast
linuxguyEastCoast
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
169
huiettcm
huiettcm

Part and Inventory Search

Sponsor

Back
Top