Macro to open multiple text files and perform operations in each one. Then copy results.

Hello, this is the situation

I´ve a folder with several text files, listed from 1 to 30. What i want is to open each file and sum all the values in the second column, then copy the result to a open excel file, the following code can do that only for one file, i think i have to implement a cycle, unfortunately i do not know how.

Note that "(1-30).txt" are all the files

Please Login or Register  to view this content.

I hope someone can help, what i´ve done so far is changing the index of the file, but i know that repetitive task can be replaced esaily.

Thanks in advance

Greetings

this macro would be installed INTO your destination workbook and will paste the results into a sheet called OUTPUT.

Please Login or Register  to view this content.

Code correction above. Sorry.

Code corrected above... again.

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.