Loop through files in folder

[danielgri14]

Hello,

So I am trying to loop through a large number of excel files in a folder. In each file, I want to find a maximum value from a selected range and add that maximum value in a column to a different workbook.

I found a code which loops through files in a folder but I do not think I am using it correctly.

It has been a while since I have used VBA so I am rusty.

Here is the code

Please Login or Register  to view this content.

Any help would be much appreciated


Best Regards,
Daniel

[StephenR]

Daniel - what do you mean, is the code not working, or giving you unexpected results, or something else?

[danielgri14]

So the code will first allow me to browse and select a folder, then once I select a folder I get a the message box. No data is written on the intended workbook.

[StephenR]

There's nothing in your code to write anything to a workbook. What should happen?

[danielgri14]

Well this code,

Please Login or Register  to view this content.

was supposed to record the max value into the other workbook then go down one row for the next max value.

[StephenR]

My mistake, I missed that, but I'm surprised your code doesn't error as i starts off as zero. The +1 line should come first.

[danielgri14]

I figured it out!!! My files were not .xls but a different format. I changed to myExtension = "*.*" and the code works great. Thanks for the help Stephen

[abousetta]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.