Trying to refer to Workbook in VBA, when workbook name is the combination of cells

Hey people,

I would be really happy if somebody could help me with the following problem:

I have some excel files. The Team file and the Team members files. I am trying to create a macro in The Team File to do the following:

For every Row in the Team file go to the Team members file find some information and copy them. The Members files are in the same folder and they are named after the people's names. It seams that VBA does not accept the name of the Workbook of every member, since I am trying to add it with cell references of the members names:

for r = 2 To 240
workbook ("Filepath" & wb.sh.rng.Cell(r, 2).Value & "_" & wb.sh.rng.Cell(r,3).Value & ".xls").Activate etc.

Any Ideas how I could make it work?

I would be grateful for your help.

Cheers

Thank you so much for your quick and accurate response! You really helped me a lot. And of course I realized what I had been doing wrong..

i just had to reactivate the main WB before the "lRI = lRI + 1" and it worked perfect.

Thanks a lot again.

Regards from Berlin.