View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jbsand1001 jbsand1001 is offline
external usenet poster
 
Posts: 8
Default Macro code that will look for the most recent workbook

I currently have a macro that opens specific workbooks but I wanted to know
if there was a way to tell the macro to open the most recent workbook. I
have several workbooks that are saved as "name today's date.xls".

So it would look in this folder and find either the workbook with the most
recent date or the workbook that has been save last.

Any Suggestions would be greatly appreciated.


Thank You,


Judd