Macro apply on all the file in same directory

  • Thread starter Thread starter Elton Law
  • Start date Start date
E

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
 
Back
Top