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

preview_player
Показать описание

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.
------------------------
Рекомендации по теме
Комментарии
Автор

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

currentpeace
Автор

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

jakeg