Hi,

I have a macro that searches the current directory (and subfolders) for
Excel files. What it's supposed to do with each file is take the value(s)
from two named ranges and put them into the current open workbook.

I'm having trouble getting the value(s) from the workbooks inside my loop. I
can't see any method off the .FoundFiles object to let me get the named
ranges out of the file.

Any suggestions?
George

Hi George

Start here
http://www.rondebruin.nl/copy3.htm

Try
http://www.rondebruin.nl/fso.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"George" wrote in message ...
Hi,

I have a macro that searches the current directory (and subfolders) for
Excel files. What it's supposed to do with each file is take the value(s)
from two named ranges and put them into the current open workbook.

I'm having trouble getting the value(s) from the workbooks inside my loop. I
can't see any method off the .FoundFiles object to let me get the named
ranges out of the file.

Any suggestions?
George