Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-11-2016, 08:33 AM
vince692 vince692 is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Novice
Get CustomDocumentProperties
 
Join Date: May 2016
Posts: 22
vince692 is on a distinguished road
Default Get CustomDocumentProperties

I want to read CustomDocumentProperties, here is my code but i can't get the
"ActiveDocument.CustomDocumentProperties.Count " working :
I tried with "ThisDocument.CustomDocumentProperties.Count" as well.

In Excel, "ThisWorkbook.CustomDocumentProperties.Count" works.



Code:
'Read CustomDocumentProperties in a WordDocument
Dim cp As DocumentProperty

'Check if CustumDocumentProperties exist ...
If ActiveDocument.CustomDocumentProperties.Count = 0 Then
MsgBox "Generation path not found"
Exit Sub

For Each cp In ActiveDocument.CustomDocumentProperties
    MsgBox cp.Name & vbLf & cp.Value
Next cp
End If
Any ideas ?
Reply With Quote
  #2  
Old 05-11-2016, 04:39 PM
macropod's Avatar
macropod macropod is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Change 'Exit Sub' to 'Else'.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 05-12-2016, 12:36 AM
vince692 vince692 is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Novice
Get CustomDocumentProperties
 
Join Date: May 2016
Posts: 22
vince692 is on a distinguished road
Default

I kept the Exit Sub and added Else afterwards.
It is working great.
Thanks a lot.
Reply With Quote
  #4  
Old 05-12-2016, 12:59 AM
macropod's Avatar
macropod macropod is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by vince692 View Post
I kept the Exit Sub and added Else afterwards.
The reason I suggested replacing 'Exit Sub' is that it's redundant. The code will perform just as you require with 'Else' instead. Delete your modified code's 'Exit Sub' and you'll see that is so.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #5  
Old 05-12-2016, 01:21 AM
vince692 vince692 is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Novice
Get CustomDocumentProperties
 
Join Date: May 2016
Posts: 22
vince692 is on a distinguished road
Default

If i don't find custumdocument propreties , the code i have after this following code mustn't execute ; (no need to launch an executable without all its arguments)

Code:
'Lit les propriétés personnalisées du document Word
Dim cp As DocumentProperty
Dim strSVSPath

'Vérifie qu'il y a des propriétés personnalisée
If ActiveDocument.CustomDocumentProperties.Count = 0 Then
    MsgBox "Custum properties de document non trouvé !"
    Exit Sub
Else
    For Each cp In ActiveDocument.CustomDocumentProperties
        If cp.Name = "SVS" Then
            strSVSPath = cp.Value
        Else
            'MsgBox cp.Name & vbLf & cp.Value
        End If
    Next cp
End If
'MsgBox strSVSPath
Everything is working fine. Thanks a lot
Reply With Quote
  #6  
Old 05-12-2016, 04:36 AM
macropod's Avatar
macropod macropod is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

As I keep saying, the 'Exit Sub' is redundant. You don't need it. It achieves nothing. Why else do you suppose I gave the advice I did in post #2???
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #7  
Old 05-12-2016, 06:44 AM
vince692 vince692 is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Novice
Get CustomDocumentProperties
 
Join Date: May 2016
Posts: 22
vince692 is on a distinguished road
Default

Thanks for your support.

One last question : I want to write into CustomDocumentProperties

Code:
Sub CustDocPropUpdt()

With ActiveDocument.CustomDocumentProperties
  .Item("SVS") = "C:\Users\Name\Desktop\Test\02_Multiplicate"
End With

End Sub
VB tells me argument is missing...
Reply With Quote
  #8  
Old 05-12-2016, 02:06 PM
macropod's Avatar
macropod macropod is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

I suggest you look at: https://support.microsoft.com/en-us/kb/212618
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #9  
Old 05-13-2016, 12:34 AM
vince692 vince692 is offline Get CustomDocumentProperties Windows 7 64bit Get CustomDocumentProperties Office 2010 32bit
Novice
Get CustomDocumentProperties
 
Join Date: May 2016
Posts: 22
vince692 is on a distinguished road
Default

Thank you !
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Get CustomDocumentProperties Document Variables vs CustomDocumentProperties Cosmo Word VBA 2 08-11-2014 01:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:12 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