Macro apply on all the file in same directory

[Elton Law]

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

 

[Ron de Bruin]

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