Reflection Desktop VBA Guide
Attachmate.Reflection.Objects Library / Attachmate.Reflection.Objects.Web.Msie Library / WebDocument Object / Extract Method
Example
In This Topic
Extract Method (WebDocument)
In This Topic
Extracts text delimited by pretext and posttext from an HTML text source.
Syntax
expression.Extract( _
   ByVal pretext As String, _
   ByVal posttext As String, _
   ByVal singleLine As Boolean _
) As String()
where expression is a variable that represents a WebDocument Object

Parameters

pretext
posttext
singleLine
Example
This sample extracts text from a Web page and prints the text.
'This sample gets text on a Web page
Sub extract()
 
    Dim app As Attachmate_Reflection_Objects_Framework.ApplicationObject
    Dim text() As String
    Dim webText As String
    Dim size, i As Integer
    
    'Get a handle to the workspace
    Set app = GetObject("Reflection Workspace")
 
    'Go to a Web page
    ThisWebControl.Navigate1 "https://www.microfocus.com/documentation/reflection-desktop/17-0/vba-guide/AboutVBA.html"
 
    'Wait until the document is ready
    Do Until ThisWebControl.ReadyState = WebBrowserReadyState_Complete
      app.Wait (1000)
    Loop
    
    'Get the text on the first paragraph
    text = ThisWebControl.Document.extract("Visual Basic for Applications", "objects", False)
    
    'Get the size of the array that is returned
    size = UBound(text) - LBound(text) + 1
 
    'If text is returned, print the text
    If size = 0 Then
        Debug.Print "Did not find text"
    Else
        For i = 0 To UBound(text)
            Debug.Print text(i)
        Next
    End If
    
End Sub
See Also