List All Files (From a Selected Folder) | Excel VBA Macro

Excel VBA Macro: List All Files (From a Selected Folder). In this video, we go over how to use Application.FileDialog(msoFileDialogFolderPicker) to allow a user to select a folder, and use our code to return the names of all of the files in that selected folder.
This is a modification of code from: www.thespreads...
#ExcelVBA #ExcelMacro

[@greggowaffles]

List Time Last Saved (For All Files In Folder) 😎😎: ruclips.net/video/7qnO37TsojE/видео.html

[@satyamjha7402]

Nice and simple!

[@greggowaffles]

Glad you like it!

[@M4KE4W1SH]

Glad to see you posting new videos! Enjoying your content, my guy!

[@greggowaffles]

appreciate that! thanks for the support 💪

[@WAHbappin]

Is there a way to display the files when selecting a folder to check the contents rather than seeing if anything populates?

[@gerryf789]

Can you edit the script to list the files starting at cell A2 or B2 so you could leave a permanent header?

[@benfoldin21]

Great job!! Can you think of a way it's possible to add other info about the files like date last saved possibly?

[@greggowaffles]

thanks! you can use the below to grab that data. I'll make a video on this asap
LastSavedTimeStamp = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")

[@greggowaffles]

here you go! ruclips.net/video/7qnO37TsojE/видео.html

[@brokenmind88]

thanks man... 👍

[@joanagonzales2775]

Is there a way to find a list of files and extract it as well

[@greggowaffles]

Just made a video on that topic. Hope it helps! Excel VBA Macro: Extract Data from All Files in a (User Selected) Folder
ruclips.net/video/9o6t6c_a7rY/видео.html

[@nellaimuthuvels7099]

how to do it for MAC version, filesystemobject not exisit error is there..please help

[@x4ms]

it works like a charm!

[@greggowaffles]

Niiiice!!! Glad to hear that!!