I want be able to have the code update automatically. below is the cod
now, I need to manually update the filename every day as a new one i
created everyday, how can I put in code that knows that tomorrows fil
will be AR042904.xls. I also need to look at the previous days fil
name too. Any ideas
Workbooks.Open Filename:="K:\Collections\Client AR\AR042804.xls

--
Message posted from http://www.ExcelForum.com