This is one of two approaches inspired by Dick Kusleika’s post on opening in Excel the newest CSV file in a given folder (http://www.dailydoseofexcel.com/archives/2009/05/01/opening-the-newest-file-in-a-folder-with-vba/).
I explain the development of the Excel 2007 add-in at http://www.tushar-mehta.com/publish_train/xl_vba_cases/LINQ_newest_file.htm. The key issues addressed are the use of LINQ to query the file directory to find the newest file and using a Ribbon as the UI for the Excel 2007 add-in.
Posting code? Use <pre> tags for VBA and <code> tags for inline.