This is one of two approaches inspired by Dick Kuslekia’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 [...]
Read More...
Read the complete post at http://www.dailydoseofexcel.com/archives/2009/05/06/using-linq-to-find-and-open-in-excel-2007-the-newest-file-in-a-folder/
Posted
May 06 2009, 02:50 AM
by
Daily Dose of Excel