Getting Range whilst looping through files in directory
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
|