Add search results to a single array

New edit:

Hi guys,

I'm looking to do the following:

Search for a keyword in a file
paste the results of that keyword into a cell in a workbook (i.e. the folder that contains that keyword)
Then loop again for the same keyword (in case there is more than one folder)
If not then simply end the loop

Does anybody have any ideas they can help me with, I seem a bit frazzled and cant get it started.
I know what I need, I just simply cant get my head around i.e.

Keyword = search....

For 1 to ubound etc

any ideas?

Thanks a lot!