Results 1 to 9 of 9
  1. #1
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Referencing Document Properties (2003/SP2)

    Is there a function for referencing document properties in a cell, in a similar way to word?
    I've been looking - but it seems that VBA is the only way to do this.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Referencing Document Properties (2003/SP2)

    There is no equivalent in Excel of Word's DOCPROPERTY field, so you have to use VBA

  3. #3
    Silver Lounger
    Join Date
    Dec 2000
    Location
    California, USA
    Posts
    1,758
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referencing Document Properties (2003/SP2)

    Catharine,

    Try this link. I use it to obtain property information of an Excel file.

    Regards,
    John

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Referencing Document Properties (2003/SP2)

    Catharine asked if there was a way to do it without VBA.
    DSOFile is a way to read document properties in VB/VBA without opening the document. In an open workbook, there is no need to use that.

  5. #5
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Document Properties -Linking

    As you can see from the attached graphic there is a checkbox which I assume links the contents of a property to a range or cell.
    I can't figure out how to activate it.
    Any ideas?
    Attached Images Attached Images
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Document Properties -Linking

    The check box will be enabled if you have defined named ranges in the workbook.
    If you tick the check box, the Value text box becomes a dropdown list named Source. You can select a defined name from the list.
    If the named range consists of multiple cells, the document property will have the value of the cell in the upper left corner.

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Document Properties -Linking

    Ok, nothing like answering oneself.
    You must create the named ranges FIRST then the linked checkbox will be available, once checked the dropdown value list will show all the ranges in the workbook.
    It will only store the value from the first cell in the range.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  8. #8
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Document Properties -Linking

    Holy cow - I can't even talk to myself faster than you can type [lol]
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  9. #9
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Document Properties -Linking

    Twelve-finger typing helps... <img src=/S/innocent.gif border=0 alt=innocent width=20 height=20>

Posting Permissions

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