Excel VBA To Open & Import Last Created/ Most Recent Workbook in Folder

Get the code here www.bluepecant...
This video demonstrates how to open the last created or most recently created workbook within a folder and then to copy or import that date into the current workbook. The solution uses VBA's FileSystemObject.
------------------------

[@fichoardianto5120]

Thanks for this video…

[@currentpeace]

Hello, thanks for this video! I used this macro for a few days, the weird thing happened... Macro stops at the start and highlights: Dim fso As scripting.filesystemobject
and says: User defined type not defined. What is the mistake? thank you

[@jakeg9711]

Is it possible to have this trigger automatically when a new file is added ?