Thread: Macro apply on all the file in same directory
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Elton Law[_2_] Elton Law[_2_] is offline
external usenet poster
  
Posts: 173
Default 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
Reply With QuoteReply With Quote