Results 1 to 2 of 2
2007-10-02, 16:59 #1
- 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.
2007-10-02, 17:17 #2
- Join Date
- Mar 2002
- Thanked 30 Times in 30 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.