Hi Folks,
It's times like this that I wish I studied programming!
Looking for code that will evaluate every file in a directory, pull in the value from two specific cells from each file, and place them sequentially in one workbook - one pair of values per row.
I used this code to get values from a closed file, but am not sure how to add a second value, or step through any number of files in a directory.
I appreciate your help!
-- Scott
It's times like this that I wish I studied programming!
Looking for code that will evaluate every file in a directory, pull in the value from two specific cells from each file, and place them sequentially in one workbook - one pair of values per row.
I used this code to get values from a closed file, but am not sure how to add a second value, or step through any number of files in a directory.
I appreciate your help!
-- Scott
