Hi all,
I would need help with following problem ... I have structure on disk where are folders with years, than subfolders with months and in each subfolder can be workbook with several sheets. I need to go thru all folders/subfolders/workbooks/sheets.
To find folders/subfolders/workbooks is not the problem. Problem is to go thru all sheets and pick-up the value from each sheet.
Thank You very much in advance for Your help.
Please Login or Register to view this content.
Greetings
Martin
Last edited by martyzeman; 05-09-2014 at 05:40 AM.
You have to open each file and go thru all sheets like this
Please Login or Register to view this content.
Hi lancer102rus
Yes that would be the way, I thought if it would be possible without opening of the other workbooks. Any idea?
You can do this only with ADO
Please Login or Register to view this content.
Thank You lancer102rus, I don't understand ADO, so I did it with opening each workbook. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks