extract certain values from multiple workbooks into a new file
 

Hi, I'm hoping somebody could help me with this problem. It's pretty
simple, but an Excel script would be the first for me, although I'm
not a complete newbie to scripting. I could use some reverse
engineering insight.

Ok, here is my problem. I have multiple files, all based on the same
template. I'd like to create a new file with values from I39 and I40,
which would include the file name, and these two values in rows.

If it makes it any easier, I've extracted the file names by piping DIR
into a file, so the script could use those as file name index.

A big thanks for all help.

extract certain values from multiple workbooks into a new file
 

See
http://www.rondebruin.nl/merge.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


wrote in message ...
Hi, I'm hoping somebody could help me with this problem. It's pretty
simple, but an Excel script would be the first for me, although I'm
not a complete newbie to scripting. I could use some reverse
engineering insight.

Ok, here is my problem. I have multiple files, all based on the same
template. I'd like to create a new file with values from I39 and I40,
which would include the file name, and these two values in rows.

If it makes it any easier, I've extracted the file names by piping DIR
into a file, so the script could use those as file name index.

A big thanks for all help.