Re: Pull values from each .xls file in dir

Giganews Newsgroups
Subject: Re: Pull values from each .xls file in dir
Posted by:  Jim Cone (jim.coneX…@rcn.comXXX)
Date: Sat, 27 May 2006

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

Replies

None

In response to

Pull values from each .xls file in dir posted by Duke17 on Sat, 27 May 2006