+ Reply to Thread
Results 1 to 6 of 6

Add Windows Tags to Files

  1. #1
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Add Windows Tags to Files

    My spreadsheet reads the filenames, timestamps, and tags of all the files in the selected folder. The tags are usually applied to the files in Windows Explorer.

    I'd also like to add or tags to the files from within Excel. Is there a way to do that?

    Thanks.

  2. #2
    Valued Forum Contributor Miraun's Avatar
    Join Date
    04-03-2009
    Location
    New England
    MS-Off Ver
    2003, 2007, 2010, 2013
    Posts
    554

    Re: Add Windows Tags to Files

    Yes! The file properties are stored in the ThisWorkbook.ContentTypeProperties class.

    Those are the same properties that you'd find if you use the Windows button > Prepare > Properties menu.
    Going for Guru! Click the Star to the bottom left of this post if I helped!

  3. #3
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Re: Add Windows Tags to Files

    Doesn't that show the tags of the current workbook? I'm looking for the tags of the files (jpegs, in this case) that are in a Windows folder.

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Add Windows Tags to Files

    Do mean information like this example extracts?
    https://groups.google.com/forum/#!ms...w/ZOKbUSd3KrcJ
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    09-25-2008
    Location
    Winnetka, CA
    Posts
    83

    Re: Add Windows Tags to Files

    Yes, like that. In fact I'm using code like that to extract the tags and filenames now. What I want to do is be able to MODIFY the tags in the file.

  6. #6
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Add Windows Tags to Files


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem opening xls files in windows 8
    By Mikey7346 in forum Microsoft Windows Help
    Replies: 3
    Last Post: 01-28-2013, 01:53 AM
  2. How to Convert Video Files on Mac/Windows
    By aqi57aqi in forum Excel General
    Replies: 0
    Last Post: 04-09-2010, 02:58 AM
  3. [SOLVED] Windows XP : Windows won't boot up, how to back up files?
    By jesika in forum Microsoft Windows Help
    Replies: 5
    Last Post: 11-30-2009, 06:03 AM
  4. remove files and folders in windows
    By tomro1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-08-2006, 06:21 PM
  5. [SOLVED] open excel files in different windows
    By Luciano Cunha in forum Excel General
    Replies: 5
    Last Post: 05-27-2005, 06:05 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1