Thread: For loop for each file in a folder?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kieran1028[_6_] Kieran1028[_6_] is offline
external usenet poster
  
Posts: 1
Default For loop for each file in a folder?

I've got a macro that imports a .txt file and moves the data around, an
copies some things here and there... I need to run this macro on abou
40 different .txt files in a folder. Is there a way to write
For-loop that will run the macro on EACH text file in a give
directory?

Thanks,
Kiera

--
Kieran102
-----------------------------------------------------------------------
Kieran1028's Profile: http://www.excelforum.com/member.php...fo&userid=1567
View this thread: http://www.excelforum.com/showthread.php?threadid=27701

Reply With QuoteReply With Quote