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

Поділитися
Вставка
  • Опубліковано 24 лис 2024

КОМЕНТАРІ • 16

  • @greggowaffles
    @greggowaffles  3 роки тому

    List Time Last Saved (For All Files In Folder) 😎😎: ua-cam.com/video/7qnO37TsojE/v-deo.html

  • @thebronzefury1000
    @thebronzefury1000 7 місяців тому +1

    Nice and simple!

  • @M4KE4W1SH
    @M4KE4W1SH 3 роки тому

    Glad to see you posting new videos! Enjoying your content, my guy!

    • @greggowaffles
      @greggowaffles  3 роки тому

      appreciate that! thanks for the support 💪

  • @WAHbappin
    @WAHbappin Рік тому +1

    Is there a way to display the files when selecting a folder to check the contents rather than seeing if anything populates?

  • @gerryf789
    @gerryf789 8 місяців тому

    Can you edit the script to list the files starting at cell A2 or B2 so you could leave a permanent header?

  • @benfoldin21
    @benfoldin21 3 роки тому

    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  3 роки тому

      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  3 роки тому

      here you go! ua-cam.com/video/7qnO37TsojE/v-deo.html

  • @joanagonzales2775
    @joanagonzales2775 Рік тому +1

    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
      ua-cam.com/video/9o6t6c_a7rY/v-deo.html

  • @brokenmind88
    @brokenmind88 4 місяці тому

    thanks man... 👍

  • @nellaimuthuvels7099
    @nellaimuthuvels7099 2 роки тому

    how to do it for MAC version, filesystemobject not exisit error is there..please help

  • @x4ms
    @x4ms 2 роки тому

    it works like a charm!