Month: August 2019

Excel TutorialExcel VBA TutorialTutorial

Excel VBA | Import Most Recently Created File into Current Workbook

This video demonstrates how to import the most recently created Excel workbook in a specified folder into the current workbook. The solution uses VBA's FileSystemObject. https://www.youtube.com/watch?v=ghy94Jrfjzo Here is the code featured in the video. Sub ImportMostRecentFile() Dim fso As Scripting.FileSystemObject Set fso = New Scripting.FileSystemObject Dim MyFolder As Scripting.Folder Set MyFolder = fso.GetFolder("File Path for…

Read More