Thread: Loop through a range Open a file
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
thanks thanks is offline
external usenet poster
  
Posts: 48
Default Loop through a range Open a file
Hello
I have a range AA3:AA:33 that contains either "yes" or "no". and a list of
files (myfile.csv) in A3:A33 I would like to loop through the range AA3:AA33
and if the value is yes open the coresponding file in column A. The path to
the file is previously determined by code to be MyPath.
Thanks
Reply With QuoteReply With Quote