Announcement

Collapse
No announcement yet.

How to copy files attributes from foldrs and arranged it to excel using VBA/ button?

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • How to copy files attributes from foldrs and arranged it to excel using VBA/ button?



    Can someone tell me what are the functions I need so I can just figure out to put them together. Thanks.

    or

    make tutorial on How can I extract all the files from my folder and extract it into excel with filter using just a couple of buttons?
    Like one button extracts all files from folders and subfolders that has pdf and png extensions. Other button updates the list if the files are moved or removed. Other button Prints the list correctly.


    Here is the REF video https://www.youtube.com/watch?v=mvYYZNUe_9s
    .



    This is the video I'd like to copy https://www.youtube.com/watch?v=vliCSzCrrR4&t=17s
    the guy says no need to buy expensive program when you can do it in excel yet doesnt provide an link to download the code or provide a tutorial

    .

    The video above uses buttons/vba in excel and I badly need it. This doesnt help either http://www.vbaexpress.com/kb/getarticle.php?kb_id=405 Nor this one https://www.youtube.com/watch?v=OSCPVBWOqwc




    NOTE: Im aware that there is a software called Directory List but this is not what I want. I want knowledge and share it to others.

  • #2
    Welcome to the forum!

    It looks like you changed your username in those links and this one cross-posted to: https://www.reddit.com/r/excel/comme...m2&sh=2d1b09d4

    See this link for cross-posting etiquette. https://www.excelguru.ca/content.php?184
    and, http://www.vbaexpress.com/forum/show...-using-buttons

    I hope you weren't the one that used UPPERCASE and repeated the same request over and over again in one of the youtube links.

    "Doesn't help" is incorrect. The VBAExpress link is extremely helpful. It shows you not only how to find the files but how to READ MetaTag properties or "file attributes". I have not checked to see if OneDrive folder of files can be read that way.

    Even using the READ method, the youtube videos also indirectly shows WRITING to the file attributes. The code is not shown how it does that. To do that, you must have a 3rd party application or a file with routines to do it like dsofile.dll. The latter is starting to show its age and mainly for Microsoft Applications anyway. See this discussion about MetaTags. http://www.eileenslounge.com/viewtop...28298&p=219422

    Without the ability to WRITE metatag properties via VBA, I don't see much point in letting a user do it in the Excel file. I guess you can play with the previous link recommend 3rd party tool. https://sno.phy.queensu.ca/~phil/exiftool/
    One would use Shell() to run it and pass the filename and MetaTag with property value to write as a command line parameter. I doubt that you want to go that route. That application is pretty large.

    Comment


    • #3


      Originally posted by Kenneth Hobson View Post
      Welcome to the forum!

      It looks like you changed your username in those links and this one cross-posted to: https://www.reddit.com/r/excel/comme...m2&sh=2d1b09d4

      See this link for cross-posting etiquette. https://www.excelguru.ca/content.php?184
      and, http://www.vbaexpress.com/forum/show...-using-buttons

      I hope you weren't the one that used UPPERCASE and repeated the same request over and over again in one of the youtube links.

      "Doesn't help" is incorrect. The VBAExpress link is extremely helpful. It shows you not only how to find the files but how to READ MetaTag properties or "file attributes". I have not checked to see if OneDrive folder of files can be read that way.

      Even using the READ method, the youtube videos also indirectly shows WRITING to the file attributes. The code is not shown how it does that. To do that, you must have a 3rd party application or a file with routines to do it like dsofile.dll. The latter is starting to show its age and mainly for Microsoft Applications anyway. See this discussion about MetaTags. http://www.eileenslounge.com/viewtop...28298&p=219422

      Without the ability to WRITE metatag properties via VBA, I don't see much point in letting a user do it in the Excel file. I guess you can play with the previous link recommend 3rd party tool. https://sno.phy.queensu.ca/~phil/exiftool/
      One would use Shell() to run it and pass the filename and MetaTag with property value to write as a command line parameter. I doubt that you want to go that route. That application is pretty large.
      Noted, thanks!

      Comment

      Working...
      X