Hi there
I am very new to VB but I need advice.
I would like to write some VB code that I can point to a directory (and it's subdirectories) to identify the excel files in there and pull fields out of each file, into a new excel file. The fields will be in the same location in each file.
What is the best way to do this? Is there a script out there that already does this?
What I want to avoid is having someone have to manually open up and copy each of these fields to a new file (there are over 500 excel sheets).

thanks for your help in advance!
melyss