Retrieving from a folder files w/same date

[Lisa]

I need to compile information from different Excel workbooks into a master workbook. However, there are variable workbooks in the folder from which i need to extract the data. What do i have to write in a macro to do the following
1) Go to a specific folde
2) Find the files with a specific yea
3) Retrieve data from those specific workbook

Thanks
Lisa

 

[Chad DeMeyer]

Lisa,

You should be able to accomplish the first two items using the
FileSystemObject. See the MSDN Library article
http://msdn.microsoft.com/library/en-us/script56/html/FSOoriFileSystemObject.asp.
Using FSO, you can get the filename of these files that fit your criteria,
and then open those files and retrieve your data using the native Excel
object model.

Regards,
Chad

I need to compile information from different Excel workbooks into a master

workbook. However, there are variable workbooks in the folder from which i
need to extract the data. What do i have to write in a macro to do the
following: