+ Reply to Thread
Results 1 to 2 of 2

Function to access custom fields in Properties

  1. #1
    Hall
    Guest

    Function to access custom fields in Properties

    Is there a function that can retrieve the value of any particular custom
    field in the file's Properties? Word has this but I can't find it in Excel.



  2. #2
    Gord Dibben
    Guest

    Re: Function to access custom fields in Properties

    Hall

    Copy/paste this User Defined Function to a module in your workbook.

    Function DocProps(prop As String)
    Application.Volatile
    On Error GoTo err_value
    DocProps = ActiveWorkbook.BuiltinDocumentProperties _
    (prop)
    Exit Function
    err_value:
    DocProps = CVErr(xlErrValue)
    End Function

    =DOCPROPS("last author")
    or
    =DOCPROPS("last save time")


    Gord Dibben Excel MVP

    On Wed, 15 Jun 2005 21:59:56 -0400, "Hall" <hall@garp.org> wrote:

    >Is there a function that can retrieve the value of any particular custom
    >field in the file's Properties? Word has this but I can't find it in Excel.
    >



+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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