Hiya,

I just wanted to find out if it would be possible to get a macro to loop through an entire folders files (excel) open them, copy some data over, then close them. (100's) of them

This is on the assumption you dont know the exact string name of these files.

The data is all in same format.

What i kinda need is it to list the filenames into a colum, then i can get my macro to go down the list one by one...

I have the code to open a workbook & i know how to use counters to loop through the operation, just cant think of how to get all the workbook names.

Any help would be greatly appriciated.

Cheers,