Reading Office 2007 document Properties from Access 2007 code without opening the document (e.g. Word 2007).
Posted on 2009-03-30
I want to read the Properties (Author, Title, Subject etc.) of Office documents such as Word 2007, Excel 2007 and PowerPoint 2007 without opening them, from VBA code in Access 2007. Is this possible and if so, how? For the sake of discussion, it would probably be best to take the case of reading document properties for a Word 2007 file (call it: "TestDoc.xlsx" located in a folder "C:\TestFolder"). I appreciate any help on this. Thanks.