Need help combining two codes

I have two codes, one that auto selects a file based on a partial title, and the other that copies and pastes.

Please Login or Register  to view this content.

After running the program I keep getting this message, "Run-time error 91: Object variable or with block variable not set"

Hi, on what line of code does it error?

None of the lines shows any indication there is an error, but I would imagine somewhere after the "copy range" line. The file opens automatically, but after it opens this message opens, "Run-time error 91: Object variable or with block variable not set"

At a guess it's failing on this line

Please Login or Register  to view this content.

because the variable in blue has no value

any recommendations to remedy this?

Give it a value
ie

Please Login or Register  to view this content.

ohhh "wsCopyFrom" shouldn't be highlighted. My code is showing only the "Set" is highlighted

You have used Set a number of times in your code, which one is getting highlighted?

The "set" from the same line: Set Fnd = wsCopyFrom.Range("5:5")

Have you set wsCopyFrom before that line?

hmmm no but for a previous code I didn't and it worked fine

If you haven't assigned a worksheet to the variable, then the code will not work.

this is my original code that allows me to open a file and select a file:

Please Login or Register  to view this content.

I am trying to integrate this portion of it:

Please Login or Register  to view this content.

Together is what my original post was about, how would one go about combing the two because I am completely lost.

Just add this line from

Please Login or Register  to view this content.

your original code to your new code to the new code after this section

Please Login or Register  to view this content.

omg for some reason one of the lines were missing that's why it wasn't working, thank you so much!! is there one more thing you could help me with? I have to do the same thing with 3 workbooks (in the same file), is there anyway I can make workbook one auto select 1 file and copy and paste, then workbook 2 auto select a different file then copy and paste, etc.. with one click of a button?