How to specify file name in a formula used in VBA when looping through multiple files?

[kotonikak]

I'm currently looping through multiple files using the following code:

Please Login or Register  to view this content.

Inside the loop, I have the following code, which does a SUMIF formula in one of my columns:

Please Login or Register  to view this content.

Since I am looping through all of the files, how would I change the part of the code with the file name (code below) to pick each new file and not a fixed one like I have above?
LastRow is 234 so the file and cell reference is:

Please Login or Register  to view this content.

Each file has the same exact format.


PLEASE HELP!
Thank you!

[Chippy]

Untested, but try:

Please Login or Register  to view this content.

I'm not sure what the BD variable is, when you use wb in the For Next loop. Also, each workbook could be opened in the While Loop and get rid of the For Next loop altogether.

[kotonikak]

Thanks I'll test it out when I get back to work on Monday!