Reference already open 2nd workbook

[KMKfan]

I need help referring to an already opened 2nd workbook. Here's what I have.

The first workbook contains a listing of Excel files as hyperlinks.

Clicking a hyperlink opens a second workbook, which the user must evaluate and make changes.

After making changes, the user needs to send new data in the second workbook back to the first workbook (which is still open).

I am currently running the following macro from the 2nd workbook (the one that has the data I need to send to My_List)

Any solutions or alternative approaches?

Thanks

Sub Send_MyData()
Dim My_List As String
Dim wb1 As Workbook, wb2 As Workbook
Set wb2 = ThisWorkbook
My_List = wb1.Sheets("Summary").Range("QAList_Path").Text
Set wb1 = Workbooks(My_List).Activate 'Error occurs here

'Expected function or variable when using "Workbooks(My_List)"
'Subscript out of range when using "Windows(My_List)" where My_List is Fullname of workbook
'Object required when  using "Windows(My_List)" where My_List is Name of workbook


'Code to find correct record number
'Code to send info back to the original workbook

Set wb1 = Nothing
Set wb2 = Nothing

End Sub

 

[KMKfan]

Solved.