Pull values from each .xls file in dir

Giganews Newsgroups
Subject: Pull values from each .xls file in dir
Posted by:  Duke17 (Duke17.28hj7m_1148765101.2077@excelforum-nospam.com)
Date: Sat, 27 May 2006

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

Replies