For every directory in C:\temp\ I need to look in the directory and open up
Temp1.xls. Then I'll have to do a vlookup on each file and return the
results to a new spreadsheet. The directories I'm looking in are all dates
and I'm compiling the results by date, into one spreadsheet. Does anyone
have any ideas on how I can look in each directory and open Temp.xls? I'm
using visual studio by the way, but If you have VBA knowledge this will be
helpful as well. I have this so far:

Dim s as String
For each s in System.IO.Directory.GetDirectories("C:\temp\")
'open Temp.xls
'do vlookup
next s

Does this make sense? Thanks in advance!