Macro apply on all the file in same directory
 

Dear expert,
I'm using Excel 2007.
Have written a macro and would like to apply on all the files in a diectory.
Say C:\BONY\ASTRO\PROJECTION\

If I have another request, if ... I want to just run on the files which
contains words "20091028"
Is it difficult?

Thanks
Elton

Macro apply on all the file in same directory
 

Hi Elton

Try this
http://www.rondebruin.nl/copy4.htm

You can replace the red part with the code you want to run

contains words "20091028"
Read tip 2 about this


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Elton Law" wrote in message ...
Dear expert,
I'm using Excel 2007.
Have written a macro and would like to apply on all the files in a diectory.
Say C:\BONY\ASTRO\PROJECTION\

If I have another request, if ... I want to just run on the files which
contains words "20091028"
Is it difficult?

Thanks
Elton