This Excel video tutorial will show you how to retrieve a list of file names from a folder directly into Excel. We'll explore three efficient methods that will help you streamline the process of accessing file names without manually searching or copying each one: using the FILES function, utilizing file and web browsers, and employing an Excel VBA macro.
You can read more about it here( or get VBA code or formula):
Time Stamps
00:00:21 Method 1 - Using FILES Function
00:01:28 Method 2 - Using File and Web Browsers
00:02:32 Method 3 - Using Excel VBA Macro
Learn Microsoft Excel Online Free: