View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bigfoot17 Bigfoot17 is offline
external usenet poster
 
Posts: 67
Default Open latest file

I usually don't do as well with questions asked on Friday, but I need to
anyway.

I have one user adding files to a folder using a common name and date scheme:
"File 012909.xls"
"File 020509.xls"
"File 021209.xls"
"File 021909.xls" etc.

What I have been setting up is a control panel for a user so they do not
need to mess with lengthy pathnames etc. I would like to be able to click a
button on the control panel to open the latest version of "File" in the
folder. Any suggestions?