Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-15-2023, 09:36 AM
Ddadoo57 Ddadoo57 is offline How to recover the advanced properties of a closed document? Windows 11 How to recover the advanced properties of a closed document? Office 2021
Advanced Beginner
How to recover the advanced properties of a closed document?
 
Join Date: Feb 2023
Posts: 71
Ddadoo57 is on a distinguished road
Default How to recover the advanced properties of a closed document?

Hello,

Do you know how, in vba, to get the advanced properties of a closed .docx document?



CreateObject("Scripting.fileSystemObject") ou CreateObject("Shell.Application") allows you to get some standard properties, but not all the properties found (dor example the name of the Modele .dotm) in the Details tab of the Properties window for a file (i.e.: right click on the file, then Properties, then the Details tab)

Greetings,
David
Reply With Quote
  #2  
Old 03-17-2023, 03:55 AM
Ddadoo57 Ddadoo57 is offline How to recover the advanced properties of a closed document? Windows 11 How to recover the advanced properties of a closed document? Office 2021
Advanced Beginner
How to recover the advanced properties of a closed document?
 
Join Date: Feb 2023
Posts: 71
Ddadoo57 is on a distinguished road
Default

Hi,

If I don't find a solution, I'll add a keyword during the creation of the document with: myDoc.BuiltInDocumentProperties("Keywords").Value = myKwd, so I can retrieve it even if the file is closed. It's a bit of a fiddle but it should do the trick.

Have a nice day,
David

Last edited by Ddadoo57; 03-17-2023 at 06:25 AM.
Reply With Quote
  #3  
Old 03-17-2023, 06:24 AM
Ddadoo57 Ddadoo57 is offline How to recover the advanced properties of a closed document? Windows 11 How to recover the advanced properties of a closed document? Office 2021
Advanced Beginner
How to recover the advanced properties of a closed document?
 
Join Date: Feb 2023
Posts: 71
Ddadoo57 is on a distinguished road
Default

Hi,

If I don't find a solution, I'll add a keyword during the creation of the document with: myDoc.BuiltInDocumentProperties("Keywords").Value = myKeyW, so I can retrieve it even if the file is closed. It's a bit of a fiddle but it should do the trick.

Have a nice day,
David
Reply With Quote
  #4  
Old 03-17-2023, 06:30 AM
Ddadoo57 Ddadoo57 is offline How to recover the advanced properties of a closed document? Windows 11 How to recover the advanced properties of a closed document? Office 2021
Advanced Beginner
How to recover the advanced properties of a closed document?
 
Join Date: Feb 2023
Posts: 71
Ddadoo57 is on a distinguished road
Default

Hi,

If I don't find a solution, I'll add a keyword during the creation of the document with: myDoc.BuiltInDocumentProperties("Keywords").Value = myKeyW, so I can retrieve it even if the file is closed. It's a bit of a fiddle but it should do the trick.

Have a nice day,
David
Reply With Quote
  #5  
Old 03-18-2023, 05:23 AM
Stuart_C2 Stuart_C2 is offline How to recover the advanced properties of a closed document? Windows 10 How to recover the advanced properties of a closed document? Office 2013
Novice
 
Join Date: Feb 2020
Posts: 3
Stuart_C2 is on a distinguished road
Default

Do some googling for DSOFile.dll, which lets you read properties from docs without opening them. See if it does what you need.
Reply With Quote
  #6  
Old 03-20-2023, 01:46 PM
Ddadoo57 Ddadoo57 is offline How to recover the advanced properties of a closed document? Windows 11 How to recover the advanced properties of a closed document? Office 2021
Advanced Beginner
How to recover the advanced properties of a closed document?
 
Join Date: Feb 2023
Posts: 71
Ddadoo57 is on a distinguished road
Default

Quote:
Originally Posted by Stuart_C2 View Post
Do some googling for DSOFile.dll, which lets you read properties from docs without opening them. See if it does what you need.

Thanks for your feedback, Stuart_C2!

Do you know where I can find this dll in a secure way?

Best,
David
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing Required Document Properties - Sharepoint Properties jason1984 Word 2 06-05-2022 10:06 PM
How can I recover a word document that was 'Saved-over' with another (old) version of same document? Mrsolace Word 2 09-10-2021 10:50 AM
How to recover the advanced properties of a closed document? Word crashes if the merged document file is closed first reidtaylor Mail Merge 7 05-07-2019 04:19 AM
Macro to display Advanced Properties? XmisterIS Word VBA 0 04-24-2014 03:13 AM
How to recover the advanced properties of a closed document? Updating Document Properties without using advanced properties dialogue thedr9wningman Word VBA 3 01-20-2014 05:56 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:38 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft