View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Duke17
 
Posts: n/a
Default Pull values from each .xls file in dir


I have a directory of X amount of .xls files. They are all in the same
format, just different numbers. I would simply like to use a bit of
code to scan through every file and copy 2 different cells into one
line of a .txt file. The results would be like:

139 $1,000.00
244 $3,235.54
456 $ 896.66