Excel vba, find sheet between workbooks with variable condition

Hi Guys,

I'm running into an issue here!

I'm not experienced with excel, but I have a soft understanding of it.

Most of the steps are already done (I Think ) but the major issue is finding the sheet between workbook1 and 2 depending on the ComboBox value. Then I want to paste the information on the target sheet.
So my logic is..

.Set the workbook1 and 2 directories
.If the WB2 sheet is = to the WB1 Combobox value, then the found sheet should open. (here is the main issue)
.Paste the data onto the specific range in that sheet
.Save and close WB2 and return to WB1

The code that I already have:

HTML Code: 

Hopefully, you guys and give me a hand on it.

I figured out!

1º I made it open the workbook with the file address
2º I activated that same workbook
3º Made a string that find the ComboBox value so it can find the sheet name and it worked perfectly !!
4º It uses that string to paste the info onto the other workbook

I'm going to leave the code here just in case any of you have the same issue in the future

Please Login or Register  to view this content.