Searching For Files with Dates

S

sa26

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.
 
B

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)

sa26 said:
Here is my present problem. I have a macro on 7 workbooks that save them
Click to expand...
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.
 
Top