Hi Leith,

Firstly thanks for taking the time to reply and secondly apologies for my initial post not being clear.
1) When you say "point it at a directory", do you mean the directory path should be hard coded in your macro?
Ideally not. When the current macro is run a browser window is opened allowing me to navigate to a directory.

2) Currently the macro is returning all Word .doc files but you only want Word files like log*.doc?
Kind of. I have a root directory in which there are 200 ish folders. Each of these folder can have additional sub folders. A file called “log.doc” can appear in any folder so I would like the macro to do a recursive search for files specifically called “log.doc”.

3) Is the macro successfully returning the First FormField result?
Yes it is. It is just very inefficient because each time the macro is run it goes through every file again and reads out every FormField, then appends the results to the end of what I previously had which is time consuming and leaves me with many duplicates.

I hope this is clearer?

Thank you