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
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