Results 1 to 2 of 2
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Thanked 1 Time in 1 Post

    Excel and pdf file properties (Excel 2003)

    I need to keep track of a folder of pdf files in an Excel file. Rather than open each pdf file and then type in the proper text in the Excel file -- I'd like to type the text in the "properties" of the pdf file using the Description values on the Summary tab. I would right-click on the pdf file, type in the stuff i want to track on the Summary tab, and then I'd like to have a macro in Excel read these properties and fill in the Excel file automatically. Is that possible? Thank you for the help.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 31 Times in 31 Posts

    Re: Excel and pdf file properties (Excel 2003)

    Microsoft has a COM component that lets you edit document properties without actually opening the document. You can download it (for free) from The Dsofile.dll files lets you edit Office document properties when you do not have Office installed. Although primarily intended for use with MS Office documents, it can be used to read (and edit) the summary properties of other types of files too.

    The download comes with demos and sample code, study this carefully to see how to use it.

Posting Permissions

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