Code to do a Vlookup of an Excel spreadsheet from Word

[Phixer]

Goto HERE for the code I have been working with.

I have a problem with this line:

Please Login or Register  to view this content.

The problem is that the cell position (the (7, 2) part) isn't going to always be correct. The number of rows in the destination sheet will change, but the first column will always have the same text as the source.

I need to do a Vlookup of the value from this value:

Please Login or Register  to view this content.

from the first column of the sheet being pulled from below and pull the value from the second column:

Please Login or Register  to view this content.

[Phixer]

For the record, this is the code that worked.

Please Login or Register  to view this content.