Excel VBA Introduction Part 22 - Files and Folders (FileSystemObjects)

By Andrew Gould

[MyAudioBookCompilation]

This is the video that helped me created my method on how to create an exe file and installation package for excel projects. This is my most favorite channel in youtube. Everytime I found someone who is asking how to learn vba the very first answer that always came into my mind is the Wise Owl Tutorials. All the credits goes to Mr. Andrew Gould. Best mentor and teacher. 😀

[daves]

Just perfect. Spent a whole day researching and testing code then remembered you’ve already aced this training. Thanks again

[inactiverahul]

Wise Owl, as usual is on the top. The simplest, thus - more convenient way to deliver the knowledge to the audience.
Thanks for these wonderful videos, Andrew.

[wowJhil]

I am here so many years later, but this is SO valuable. I am a slow learner, but when I get good information like this it's not hard to learn! Actually I watch this whole video carefully, to better understand a code I had found and already used. I had a functioning code, but this video helped me understand it better, tidy up some undeclared variables and also skip some unnecessary code since there is this extension of file functionality in Runtime library. Eventually, slowly but surely, I will have watched every video carefully :)

[ashokkandukury]

deep enough to loose must loop through this until I understand. Anyway you are the best Andrew

[zozozozo]

Andrew Gould is a Giant, Giving and kind person . He does not skimp in listing the details neither in listing the side notes of some idea even if he does not use it in the code. He is a quiet person, and fortune for all people. So, I instancy pray Allah to Keep you and Choose for you all the best in this life and the other Eternity One!! ~ Assem

[AnilSharma-sgqw]

So in just 50 mins, you learnt how to work with FSO recursive function call demonstration was outstanding.

[DucLe-tcps]

I rarely comment on any videos and tutorials; however, this is one of those exceptions. Your tutorials are top-notch, and your technical explanation style is terrific, as well. I wish more people discover your channel and reap the tremendous benefit you are offering. I am going to make a donation as well. Thanks for the knowledge.

[tommik]

This video was the core step for me to start using that MS Scripting Runtime in my MS Access project. Thank you so much! It is a real shame that they were not able to integrate full Unicode support into VBA environment and using this FileSystemObject etc. approach solves the problem. Finally I am able to handle Unicode strings on file system level straight from MS Access code!

[tigranhayrapetyan]

One of the best & useful videos for VBA programming. Recursion is explained on the highest level. I want to use it in many routines in work, but before this moment didn't understand how exactly it works. Now It's time for recursion! Thank you for such a good tutorials!

[KM-comx]

Thank you for showing us several examples of using Objects (FileSystemObject, Auto Instancing, CreateObject) and the Pros and Cons thereof! Very helpful. 😁

[mdimrana]

So clear explanation is in your tutorials. Keep it up!

[Yangar]

Andrew The Wise Owl, you are awesome!!! Your videos are great, it really digs deep and are very comprehensive. I am glad I found you online.

[wulp]

Nice one again. Tip: To get the folder and the filename: Shift-right-click the file and select: "Copy as Path". Pasting this will paste the folder name and the filename between double quotes.

[twrbells]

Excellent video. Clearly explained and moves at a good pace. Now I finally understand how FileSystemObject works!

[scottn]

This is the best video in the collection! I have been struggling trying to write VB Scripting for Adobe Illustrator. All of the examples from adobe use the CreateObject method, thus killing the IntelliSense. Not to mention the documentation from Adobe is Terrrrible. This has stopped the constant page flipping and headaches.

[danraats]

Thank you for your complete and clear explanations of Excel VBA using realistic examples. I also appreciate how you also teach solid coding practices along the way.

[maurocastagnera]

Simply the best VBA video tutorials on internet! Thank you very much. You are an awesome teacher!

[maurocastagnera]

Dear Andrew, now that I understand better the English language, I appreciate more and more the enormous and fantastic work you have done with regard to vba. I hope one day to get at least half of your excellent level of preparation on the subject. You are really exceptional! Thank you very much!

[janezklun]

I just began to repeat theme with files, folders and these are just great videos for the topic, thank you, Cheers