Тёмный

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

greggowaffles
Подписаться 6 тыс.
Просмотров 9 тыс.
50% 1

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

Опубликовано:

 

19 июл 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 15   
@greggowaffles
@greggowaffles 2 года назад
List Time Last Saved (For All Files In Folder) 😎😎: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7qnO37TsojE.html
@satyamjha7402
@satyamjha7402 2 месяца назад
Nice and simple!
@greggowaffles
@greggowaffles Месяц назад
Glad you like it!
@M4KE4W1SH
@M4KE4W1SH 2 года назад
Glad to see you posting new videos! Enjoying your content, my guy!
@greggowaffles
@greggowaffles 2 года назад
appreciate that! thanks for the support 💪
@benfoldin21
@benfoldin21 2 года назад
Great job!! Can you think of a way it's possible to add other info about the files like date last saved possibly?
@greggowaffles
@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
@greggowaffles 2 года назад
here you go! ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-7qnO37TsojE.html
@x4ms
@x4ms Год назад
it works like a charm!
@greggowaffles
@greggowaffles Год назад
Niiiice!!! Glad to hear that!!
@gerryf789
@gerryf789 3 месяца назад
Can you edit the script to list the files starting at cell A2 or B2 so you could leave a permanent header?
@WAHbappin
@WAHbappin Год назад
Is there a way to display the files when selecting a folder to check the contents rather than seeing if anything populates?
@joanagonzales2775
@joanagonzales2775 Год назад
Is there a way to find a list of files and extract it as well
@greggowaffles
@greggowaffles Год назад
Just made a video on that topic. Hope it helps! Excel VBA Macro: Extract Data from All Files in a (User Selected) Folder ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-9o6t6c_a7rY.html
@nellaimuthuvels7099
@nellaimuthuvels7099 2 года назад
how to do it for MAC version, filesystemobject not exisit error is there..please help
Далее
I Built 100 Homes And Gave Them Away!
09:36
Просмотров 36 млн
Excel VBA Get File Names in Spreadsheet
8:57
Просмотров 4,5 тыс.
Excel VBA | Export List of File Names from Folder
11:55