Excel VBA process files in directory recursively
Posted on 2013-01-29
I'm looking to borrow some code from someone's extensive Excel macro library.
I just need a skeleton that does the following:
Access a directory (hard coded, say "C:\temp")
For each Excel file in the directory (*.xls, *.xlsx?):
Starting at A1, place the file name.
On the same row, copy a cell, say Sheet1!A1
Thank you in advance.