Loop through folder and add cells from each file

[Spritz]

Hello!

Here is my situation: I have a folder that has multiple files that i would like to pull data from. This data is in the same cell in each file so all i would like to do is add the total value up at the end once it finished looping through all the files and display it on my sheet. Some of these files could have 1 worksheet where others might have 3-4. If I only have 1 file in the folder it works perfectly fine but as soon as the second file opens i get a Subscript Out of Range error (See code below for the line this error occurs on). Any help is appreciated! Thanks.

Please Login or Register  to view this content.

[Solus Rankin]

Duplicate post.

[Solus Rankin]

Please Login or Register  to view this content.

Untested

[Spritz]

I get an Object or property not supported by this method error on the following line:

Please Login or Register  to view this content.

[Solus Rankin]

Sorry. That's supposed to be

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Spritz]

Works Perfectly. Thanks

[Solus Rankin]

Thanks for marking the thread as [SOLVED].

On any thread you can show appreciation to those who have helped you by clicking the * below their post.