April 12, 2012

Reopen a Previously Closed Workbook Without Referencin​g by Name

Reopen a Previously Closed Workbook Without Referencin​g by Name

 Sub dosomething()  
   Dim strLastOpen As String  
   strLastOpen = Application.RecentFiles(1).Name  
   Set wkb = Workbooks.Open(strLastOpen)  
   ' etc  
 End Sub