Hiya! I am having trouble with the syntax required to extract values from a closed workbook and place them into the active workbook. Here is what I need to do: I have an employee data file that has the first name in row B and the last name in row C. I need to loop through 75 lines and use the & command to place the full employee name in cell A1, A2, A3 etc of the open workbook.
Example. The employee file is employee.xls.
B1 = John C1 = Doe
Copy and paste "John Doe" into cell A1 of the active open workbook.

Thanks in advance