Thread: Running a macro on mulitple files
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika[_4_] Dick Kusleika[_4_] is offline
external usenet poster
  
Posts: 595
Default Running a macro on mulitple files
Chris

You can open each file in the folder using the Dir function. See here

http://www.dicks-blog.com/archives/2...-dir-function/

Then run the macro and close the file.

--
Dick Kusleika
Excel MVP
Daily Dose of Excel
www.dicks-blog.com


Chris wrote:
I want to run a macro which I have written on about 67 excel files in
one folder automatically. Is this possible? HOw?


Reply With QuoteReply With Quote