Loop Through All Files in a Folder Using VBA/Macros in Excel

Thank you. How can I get different properties (such as Contributing artists, Year, Album, etc.) of files in a folder?

Good Tutorial!
Thank you for precise and simple explanations. Found it very useful

Bonjour
Merci pour votre partage
Ma macro ne fonctionne pas au niveau de copy:=
Pourriez-vous svp m’aider
Fred

Very very helpful!!!!!!

Can we get the list of word document also?

Seen many vba tutorials, u got the right way to do this. Great work. Thank u.

Do you have a code or a tutorial video on how to generate a worksheet file whether its excel or csv format. Using vba template.

Thanks, this was exactly what I needed to know. The "Dir" function was completely new to me. I watched this video and was able to build my code with no problems at all. Thanks again.

Cool....I didn't realise Geoff Goldbloom was such an Excel expert!

Great tutorial, brilliantly explained going step by step through. This part of the code is something I was looking for to append workbooks (containing one sheets each) on top of each other something similar to power query. Thank you for the video. 👍🍀

Like the videos. How about looping through another workbook to find a value. Kind of like a vlookup or xlookup with a press of a button.

Very good explanation, thank you very much.
I offen use FileSystemObject method instead of Dir one because it provides more flexiblity for me. Also, when I use FSO, I can learn more things for example windows file directory info like hard disc size, name or file paths including extentions, modification dates, establishing dates etc.
Can you make an handy video about File System Object usage?

Thank u very much for your hard work. A quick question: do you have any tutorial on class modules in VBA ?

Good video

I really liked the flow.

Great video and amazing stuff