View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Srikanth[_6_] Srikanth[_6_] is offline
external usenet poster
 
Posts: 3
Default opening multiple files from within a macro

Hello,

I want to be able to run the same macro on say all the excel files in
a given folder. (without me having to select each file). I want to be
able to select the appropriate folder(that contains all the excel
files) and the macro should do the rest. What is the best way to do
that ? Please help.

Thanks

Srikanth