Searching For Files with Dates

[Guest]

Here is my present problem. I have a macro on 7 workbooks that save them with the date attached (i.e. "wkbk1 04-05-24.xls"). Now I need my eighth workbook to search the computer harddrive for these workbooks and perform the requisite tasks. Since I don't know the exact day that the files will be saved, can I use the "wkbk1 **-**-**.xls" as a search parameter, or do I have to go about it a different way? Any help would be great.

 

[Bob Phillips]

Check out the Dir function in help. With this you can seek out files
beginning with wkbk1, and then you would need to check the remainder to be a
date.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Here is my present problem. I have a macro on 7 workbooks that save them

with the date attached (i.e. "wkbk1 04-05-24.xls"). Now I need my eighth
workbook to search the computer harddrive for these workbooks and perform
the requisite tasks. Since I don't know the exact day that the files will
be saved, can I use the "wkbk1 **-**-**.xls" as a search parameter, or do I
have to go about it a different way? Any help would be great.

 

[Jason Hancock]

Is there a way I can ask to search a specific range of dates based on
the current system date?