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.

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" wrote in message
...
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.

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

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!