View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
igor igor is offline
external usenet poster
 
Posts: 31
Default run macro for all files in the directory

Hi,

I am trying to figure out how to run a macro for all the
files in the directory without specifying each individual
file.
I want the macro to open 1st file, run macro, close the
first file; then open the second file and do the same
thing for all other files.

Please help with the code...

Thank you
Igor