Ron de Bruin has various ways to do that at ...
http://www.rondebruin.nl/ado.htm
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"Duke17" wrote in message
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