Loop through files in a folder

Shg kindly developed this code below in a previous thread http://www.excelforum.com/excel-prog...o-columns.html and I have attempted (and failed) to make it loop through several files in the same folder. The modified code is as follows:

Please Login or Register  to view this content.

Could someone have a look and tell where I am going wrong?

Thanks.

abousetta

I finally got it to work with help from a previous post http://www.excelforum.com/excel-prog...ext-files.html. I modified the code as below:

Please Login or Register  to view this content.

I hope this helps anyone else that might have the same problem. Its still not clear what the problem was, but I noticed that my loop was not 'broken'. In any case, I hope that this post will be of help to someone else.