Copying from Excel to a table in Word

Hey all,

Trying to get a massive macro to pull information from a website, and put it in excel (done)
then it needs to sort the information into the format that I need (done)
and then I want to open up a template word document and put all of that info into an existing table (getting there, but I need help...)

A portion of the code I've been able to pull together is below:

Please Login or Register  to view this content.

For some reason the Find Replace won't work, no error, it just goes right through the code to the next part. It was working before and I don't think I changed anything in that section of code, but it won't work...

Next problem, when it runs an error comes up that says: '5941: requested member of the collection does not exist', and highlights this line: "wdTbl.Rows(W).Select"

Before the error comes up, it does manage to copy something in to the word document, but there is no text, and the color of the box is yellow.

Please point me in the right direction to fix this problem. Thanks!

Here are the two files.

1. Excel spreadsheet with the info I need to transfer.
2. Word document where I am transferring the info to the second table.