vagofone
07-19-2016, 10:09 AM
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" & Cell(r, 2).Value & "_" & Cell(r,3).Value & ".xls").Activate
etc.
next r
Any Ideas how I could make it work?
I would be grateful for your help.
Cheers
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" & Cell(r, 2).Value & "_" & Cell(r,3).Value & ".xls").Activate
etc.
next r
Any Ideas how I could make it work?
I would be grateful for your help.
Cheers