Thanks for the code Nimrod.
Retrieving data from closed workbooks is quite amazing. It pulls every Cell that is populated.
The data from the closed workbook is in different cells and not organised in a range. Is there a way to select the individual Cells in the workbook rather than a range. I am trying to pull the data from certain Cells to end up with one row of data that relates to one workbook.
Once again, the retieving of data from a closed workbook is quite amazing,
ijswalker
Retrieving data from closed workbooks is quite amazing. It pulls every Cell that is populated.
The data from the closed workbook is in different cells and not organised in a range. Is there a way to select the individual Cells in the workbook rather than a range. I am trying to pull the data from certain Cells to end up with one row of data that relates to one workbook.
Once again, the retieving of data from a closed workbook is quite amazing,
ijswalker