+ Reply to Thread
Results 1 to 2 of 2

Excel Metadata

  1. #1
    Registered User
    Join Date
    12-30-2013
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2016
    Posts
    2

    Excel Metadata

    I am new to this forum. It looks like it has a lot of really valuable information and I hope that I can also be a contributor. I have done a lot of complex Excel formulas but am new to VBA programming.

    I have an Expense Spreadsheet that works very well for my business. As I enter my expense detail, it automatically generates a string that contains the date range for this workbook. That string is displayed in a cell on my "Summary" worksheet. What I want to do is to take the date range string from the spreadsheet and update the file's metadata. That way, I can click on the filename and see the date range string (From and To dates) and then decide whether I want to look at the contents of the file or not. If I look at the standard properties in the metadata, the TAG property sounds like a logical choice.

    Does anyone have any suggestions for how I can automatically update the TAG property in the files metadata? Ideally, the macro would run every time that the spreadsheet is opened but that can be my next project.


    Thank you


    Brian

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Excel Metadata

    Is this what you're looking for?

    http://www.cpearson.com/excel/DocProp.aspx
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

+ 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. Get HTTP MetaData into Excel
    By XLS_Gunda in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 09-04-2013, 02:25 AM
  2. Metadata in Excel 2010 causing issues with sorting
    By bz6djs in forum Excel General
    Replies: 0
    Last Post: 02-14-2012, 10:27 AM
  3. how to cause Excel to find other documents based on metadata
    By smokebreak in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-25-2011, 04:02 PM
  4. Excel Metadata and HP Job Storage mode
    By gigadave in forum Excel General
    Replies: 0
    Last Post: 03-14-2008, 01:18 PM
  5. [SOLVED] How to store Metadata in the Excel Sheet (2000, XP, 2003)
    By msnews.microsoft.com in forum Excel General
    Replies: 1
    Last Post: 11-21-2005, 07:50 AM

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