Just made a video on that topic. Hope it helps! Excel VBA Macro: Extract Data from All Files in a (User Selected) Folder th-cam.com/video/9o6t6c_a7rY/w-d-xo.html
thanks! you can use the below to grab that data. I'll make a video on this asap LastSavedTimeStamp = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
List Time Last Saved (For All Files In Folder) 😎😎: th-cam.com/video/7qnO37TsojE/w-d-xo.html
Nice and simple!
Glad you like it!
Glad to see you posting new videos! Enjoying your content, my guy!
appreciate that! thanks for the support 💪
Is there a way to display the files when selecting a folder to check the contents rather than seeing if anything populates?
Can you edit the script to list the files starting at cell A2 or B2 so you could leave a permanent header?
Is there a way to find a list of files and extract it as well
Just made a video on that topic. Hope it helps! Excel VBA Macro: Extract Data from All Files in a (User Selected) Folder
th-cam.com/video/9o6t6c_a7rY/w-d-xo.html
Great job!! Can you think of a way it's possible to add other info about the files like date last saved possibly?
thanks! you can use the below to grab that data. I'll make a video on this asap
LastSavedTimeStamp = ActiveWorkbook.BuiltinDocumentProperties("Last Save Time")
here you go! th-cam.com/video/7qnO37TsojE/w-d-xo.html
how to do it for MAC version, filesystemobject not exisit error is there..please help
thanks man... 👍
it works like a charm!
Niiiice!!! Glad to hear that!!