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

Рет қаралды 8,791

3 жыл бұрын

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.thespreadsheetguru.com/th...
#ExcelVBA #ExcelMacro

Пікірлер: 16

@greggowaffles 2 жыл бұрын

List Time Last Saved (For All Files In Folder) 😎😎: kzfaq.info/get/bejne/bdeegpZoudnTmnk.html

@satyamjha7402 3 ай бұрын

Nice and simple!

@greggowaffles 2 ай бұрын

Glad you like it!

@M4KE4W1SH 3 жыл бұрын

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

@greggowaffles 3 жыл бұрын

appreciate that! thanks for the support 💪

@brokenmind88 5 күн бұрын

thanks man... 👍

@WAHbappin Жыл бұрын

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

@gerryf789 4 ай бұрын

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

@nellaimuthuvels7099 2 жыл бұрын

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

@benfoldin21 3 жыл бұрын

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

@greggowaffles 2 жыл бұрын

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 2 жыл бұрын

here you go! kzfaq.info/get/bejne/bdeegpZoudnTmnk.html

@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 kzfaq.info/get/bejne/b9Vmp5mUxMeboo0.html