Document.Body.InnerText is empty in Excel 2003

grove

Guest

Posts: n/a

17th Apr 2008

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

« RE: Find and Replace with Formatting | Text plus formula »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VBA to send Word document as body of message works in 2007, but not in 2003	Doug Robbins - Word MVP	Microsoft Outlook VBA Programming	9	16th Feb 2010 08:30 AM
Linking an Excel 2003 document copied to a Word 2003 document	=?Utf-8?B?amZn?=	Microsoft Excel Misc	7	26th Jul 2007 10:16 PM
Using VSTO to Print Excel Document without Empty Pages	=?Utf-8?B?UmljaENsYXVzc2Vu?=	Microsoft Excel Programming	0	12th Apr 2007 11:00 PM
Excel has large toolbar icons and no document body displayed	=?Utf-8?B?VG9kZA==?=	Microsoft Excel Crashes	1	27th Apr 2005 03:17 PM
Empty Message Body, outlook 2003	Diane Poremsky	Microsoft Outlook	2	10th Mar 2004 11:07 PM