hello,
I'm searching for an excel-file that searches in a directory and subdirectorys after other excel-files. These excel-files are likewise so on every file i found the tabs "1" until "20". From these tabs i need the content of cell A4, A7 and A8. Together with other information like, directory+subdirectory and filename it must come together in a table so that i have an overview of everything in the directory.
Can anyone help me, thx.
Wim
Maybe a sample excel file will explain how you want the output to be shown. Also, how many levels of sub-directories will there be?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
In attachment i have a little example of the thread. I hope you understand it,thx.
Is this the only subfolder from where the data should be consolidated?
F:\AANKOOP\Budget\Budget ELEKTRO\2. ELEKTRO
Are there chances that there will be files in this folder - F:\AANKOOP\Budget\Budget ELEKTRO\ or this folder - F:\AANKOOP\Budget\?
F:\AANKOOP\Budget\Budget ELEKTRO\2. ELEKTRO is the directory, there you can find all the excel-files from this year and then i have:
F:\AANKOOP\Budget\Budget ELEKTRO\2. ELEKTRO\Archief\2009
F:\AANKOOP\Budget\Budget ELEKTRO\2. ELEKTRO\Archief\2010
F:\AANKOOP\Budget\Budget ELEKTRO\2. ELEKTRO\Archief\2011
as subdirectorys to search in.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks