View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jodie Jodie is offline
external usenet poster
 
Posts: 72
Default Macro to open file

How would I write a macro to open the most recent excel or xml file within a
folder? I have file names that start with the same first five letters, but
the end of the file name changes according to the date of the file. On a
daily basis, my macro needs to open the most recent file created in a
specified folder.
--
Thank you, Jodie