Document.Body.InnerText is empty in Excel 2003

G

grove

This code works fine in Excel 2002


Private Sub WB_DocumentComplete(ByVal pDisp As Object, URL As
Variant)

Dim sGetText As String

If (pDisp Is WB) Then
sGetText = WB.Document.Body.InnerText

....do something with sGetText ...

End Sub


But in Excel 2003 "sGetText" is empty for the same web page.

Have I missed something here or is a change required for 2003?


Thanks

grove
 

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