Read through workbooks in a folder

[Christoffer_A]

Hello

I'm using a slightly modified code that I found on this forum, to look through all the .xlsm files in a folder, but I need help to access specific cell in two different sheets.

Please Login or Register  to view this content.

This bit of code works wonders as long as there is only one sheet I have to pull data from.
The problem arises when I need to access data from sheet2. As the loop is now, it does all the calculations on each sheet and I don't really know how to specify what sheet to draw information from.


I've edited the code below to reflect what cell that should be accessed on each sheet.

Please Login or Register  to view this content.

Any help would be greatly appreciated.

[Kaper]

try:

Please Login or Register  to view this content.

If you need to develop it further (several sheets) then instedad of

Please Login or Register  to view this content.

better construction would be

Please Login or Register  to view this content.

[Christoffer_A]

Thanks!
That worked like a charm, and I'll look into the case construction.