Excel 2007 :: How To Siphon Data From Word Document

I am currently using MS Office Excel 2007 and my limited VBA knowledge has put me at a stop of a project that I have been working on. I am trying to create an excel template that will open every word document in a specific folder and pull data located in the title of the document.

For example, I want the spreadsheet to open every document and pull info from the title that would look similar to this:

"line of business";"policy #";"dollar amount";"name";"line of business" and etc.

The semicolons in the title would partition the data across a few cells.

Below is the coding that I currently have, This is my timestamp. Column A adds a timestamp whenever data is entered into the corresponding cell in Column B. Because of this, I need data to be pulled from Word documents and inserted into Column B.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim Rng As Range
For Each Rng In Target
If Not Rng.Value = vbNullString Then
Select Case Rng.Column

[code]....

Below is some coding, but not very specified to my specific needs.

Sub SplitValue(Rng As Range)
Dim avarSplit As Variant
avarSplit = Split(Rng.Value, ";")
Range(Rng, Rng.Offset(, 4)).Value = avarSplit
If Left(Rng.Value, 2) = "RE" Or Left(Rng.Value, 2) = "FW" Then

[code]....

Also not sure if the word document is to be pulling information from the title, if I would need to negate ".doc" from data being imported.