How to Extract data into Excel using Macros?

[dxchito]

Hi,

I was wondering if there is a way to extract data from MS Word to Excel using Macros.

Heres a brief example on what I want the macros to do.

MS word:
07/01/2014
09:30 AM
1) ?6:12-bk-xxxxx-name (docket entries only) Claims Register

PRVDISM, CONVERTED


Chapter: 7
Judge:
Name and Name representing name (Debtor)

Name and Name representing Name (Joint Debtor)
Name (TR) (Trustee)

(no aty) representing United States Trustee (RS) (U.S. Trustee)

Notice of motion and motion for relief from the automatic stay with supporting declarations ?REAL PROPERTY RE: REAL PROPERTY RE: Property Address

MS Excel

Case Number |Date| Time| Judge |Debtors Lawyer|Debtor| Trustees Lawyer|Trustee | Real Property Address | Chapter|
6:12-bk-xxxxx-WJ |07/01/2014 |09:30 AM|Name | Name | Name | Name | REAL PROPERTY RE: Address

EDIT: removed sensitive personal information - Please use sample data only - Moderator

 

[L. Howard]

I've never tried it but on a google search, this looks interesting.

Regards,
Howard

        Click "Insert" and then "Module" to create a new module for entering program code. Type the following code anywhere inside the new module:

        Public Sub accessTable()

        Set appWD = CreateObject("Word.Application")

        appWD.Documents.Open Filename:="C:\WordTableData.doc", _

        ConfirmConversions:=False, ReadOnly:=False, AddToRecentFiles:=False,

        PasswordDocument:="", PasswordTemplate:="", Revert:=False, _

        WritePasswordDocument:="", WritePasswordTemplate:="", Format:= _

        wdOpenFormatAuto

        x = appWD.ActiveDocument.Tables(1).Rows(1).Cells(1)

        MsgBox (x)

        appWD.Quit

        End Sub



Read more : http://www.ehow.com/how_6873235_extract-tables-using-excel-vba.html