Understanding VBA Code: Excel VBA Programming with File System Objects (Part 3 of 4)

Please login in order to report media.

  • Uploaded 8 months ago in the category How to programming

    *********************************
    Get my VBA Troubleshooter course for only $10 http://goo.gl/S5GIBk
    *********************************

    Understanding VBA Code: Excel VBA Programming with File System Objects (Part 3 of 4)

    Video description
    ----------------------------
    The goal of my Excel VBA tutorials are to take you from a beginner level to a confident VBA developer and programmer as quickly as possible.

    The best way to do this is to help you UNDERSTAND how to code in VBA.

    A very common VBA coding task is managing files and folders: copying files, deleting files, creating folders, checking if files exist etc.

    When programming in VBA (Access or Excel) there is an excellent tool available to help us with this: the File System Object.



    The File System Object is part of the Microsoft Scripting Runtime.

    When setting up our spreadsheet we have to make sure we enable the Microsoft Scripting Runtime in the library references from the visual basic editor (VBE).

    Once we have done this we can use all of the objects in the Scripting Runtime library within our VBA code.



    In the third part of this free beginner level VBA tutorial series we use Microsoft Excel 2016.

    We continue where we left off last time and you will learn:
    1.

    How to cycle through the Files Collection of a given Folder Object in VBA code;
    2.

    How to obtain the File name and print this to the immediate window using a File System Object again within your VBA code;

    The video uses Excel 2016 but the same steps are used for Excel 2010, Excel 2013 and equivalent versions of Microsoft Access.



    If you enjoyed this short tutorial then please add a comment, start a discussion, "Like", "Favourite" or "Share" the tutorial and subscribe to my channel.




    Channel Links and Playlists
    ----------------------------
    Subscribe to Office Ninja: https://www.youtube.com/channel/UCY-6...
    Understanding VBA Code playlist: https://www.youtube.com/watch?v=hLeU0...
    Official Channel Series: https://www.youtube.com/watch?v=UDZ0r...
    Part 1 of the file system object tutorials: https://www.youtube.com/watch?v=0FDZP...
    Part 2 of the file system object tutorials: https://www.youtube.com/watch?v=J5uBH...

    Other Useful Links
    ----------------------------
    My facebook Page can be found here: https://www.facebook.com/PaulsLearningLounge
    My Blog sometimes has VBA/Excel related content: https://www.theartofquantfinance.com
    A full list of my Udemy courses can be found on my Udemy profile page: https://www.udemy.com/user/paulmorris...
    My Excel VBA Troubleshooter course is here: https://www.udemy.com/become-a-vba-tr...
    You can often find deals on my current and upcoming Udemy courses here
    https://www.theartofquantfinance.com/udemy

    WiseOwl provides a lot of very good VBA tutorials: https://www.youtube.com/channel/UCbi5...
    Sali Kaceli provides a lot of Excel and VBA related tutorials also: https://www.youtube.com/user/skaceli
    Chip Pearson has a lot of VBA content - if Chip says you should do something ...

    you probably should: http://www.cpearson.com/

    Thanks for watching!

    Paul.

  • understandingvbacode:excelprogrammingfilesystemobjectspart34