Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-29-2019, 12:49 AM
gmayor's Avatar
gmayor gmayor is offline Extract data from HTML File. Windows 10 Extract data from HTML File. Office 2016
Expert
 
Join Date: Aug 2014
Posts: 4,138
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

I would do it differently e.g.



Code:
Sub Macro1()
Dim oSource As Document
Dim oDoc As Document
Dim oRng As Range, oParaRng As Range
Dim lngP As Long
Dim sName As String, sAdd As String, sPhone As String, sExtract As String
    Set oSource = ActiveDocument
    Set oRng = oSource.Range
    Set oDoc = Documents.Add
    oDoc.Range.Font.Name = "Courier New"
    oDoc.Range.Font.Size = 10
    With oRng.Find
        Do While .Execute(FindText:="<div class=" & Chr(34) & "c-people-result__address" & Chr(34) & ">")
            oRng.MoveEnd wdParagraph, 2
            oRng.MoveStart wdParagraph, -4
            For lngP = 1 To oRng.Paragraphs.Count
                Select Case lngP
                    Case 1
                        Set oParaRng = oRng.Paragraphs(lngP).Range
                        oParaRng.End = oParaRng.End - 1
                        sName = Trim(Replace(oParaRng.Text, "</a>", ""))
                        sExtract = sName
                    Case 4
                        Set oParaRng = oRng.Paragraphs(lngP).Range
                        oParaRng.End = oParaRng.End - 1
                        oParaRng.MoveStartUntil ">"
                        oParaRng.Start = oParaRng.Start + 1
                        sAdd = Replace(oParaRng.Text, "</div>", "")
                        sExtract = sExtract & vbTab & sAdd
                    Case 5
                        Set oParaRng = oRng.Paragraphs(lngP).Range
                        oParaRng.End = oParaRng.End - 1
                        oParaRng.MoveStartUntil "("
                        sPhone = Replace(oParaRng.Text, "</div>", "")
                        sExtract = sExtract & vbTab & sPhone
                End Select
            Next lngP
            oDoc.Range.InsertAfter Trim(sExtract) & vbCr
            oRng.Collapse 0
        Loop
    End With
End Sub
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #2  
Old 08-26-2019, 01:45 PM
donlincolnmsof donlincolnmsof is offline Extract data from HTML File. Windows 7 64bit Extract data from HTML File. Office 2003
Advanced Beginner
Extract data from HTML File.
 
Join Date: Oct 2011
Posts: 36
donlincolnmsof is on a distinguished road
Default

Hello Gmayor

You modified a macro earlier and it worked great, but the search code has changed, can you fix this macro, i will really appreciate it. blow is the link to the post.

Thanks.

https://www.msofficeforums.com/word-...tml#post144478
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract data from HTML File. donlincolnmsof Word VBA 0 03-07-2019 12:17 PM
Need help to extract specific data from text file using vba victor92 Excel Programming 0 12-01-2017 12:53 AM
Extract data from HTML File. Extract Data From Text file based on Pattern PRA007 Word VBA 13 11-01-2015 11:20 PM
Macro to highlight repeated words in word file and extract into excel file aabri Word VBA 1 06-14-2015 07:20 AM
Extract data from HTML File. How to Extract key data from word iliauk Word 3 11-08-2013 04:37 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft