Putting info from each workbook in a row

[ijswalker]

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

 

[Norie]

Is this related to an existing thread?

If so perhaps you should post to that rather than creating a new one.

 

[ijswalker]

My Appologies

My appologies. Yes, it does relate to an existing threat and my query is contained in it. Its my first time on the message board and wasn't sure the last one would be looked at again.

Thanks for your help!!