list excel wookbooks and worksheets
On Wednesday, October 7, 2015 at 11:15:33 AM UTC-4, wrote:
Hi,
Is there a way to utilize a bit of VBA code that will create a list of excel workbooks in a directory with all the corresponding worksheets in an adjacent column with the contents of a specific cell, say C1, next to that?
Thanks in advance.
I'm getting a runtime error '1004', it can't find the file
|