View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stratuser Stratuser is offline
external usenet poster
 
Posts: 63
Default Need Code for Opening Old Files

I need code that will look at all the files in a subdirectory and loop
through just the ones that are older than the first of the current month,
operating on them one at a time. I used to do this with the FileSearch
command, but that's gone in Excel 2007. How could I do it now?

Thanks for your help.