Multiple file macro
 

I want to analyse data in a whole bunch of identical files. I've writte
the macro to do the anaysis but rather than copying and pasting the fil
name each time to run the macro i'd like it to do it in one hit.

Is there a command or loop which can be used to re-run the macro fo
every file within a folder.

Any help appreciated

--
RichardD
-----------------------------------------------------------------------
RichardDC's Profile: http://www.excelforum.com/member.php...fo&userid=1865
View this thread: http://www.excelforum.com/showthread.php?threadid=34588