View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sandy Sandy is offline
external usenet poster
 
Posts: 355
Default Loop through range and open files

Hello
I have a list of *.txt files in A1:F1. I have already written code to
define the path where the file is located (myPath). I need to open each file
and perform some formatting and then copy to another file. How do I loop
through the files using the content of the range?
Thanks!