Get CustomDocumentProperties

vince692 · #1 05-11-2016, 08:33 AM

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 ?

macropod · #2 05-11-2016, 04:39 PM

Change 'Exit Sub' to 'Else'.

vince692 · #3 05-12-2016, 12:36 AM

I kept the Exit Sub and added Else afterwards.
It is working great.
Thanks a lot.

macropod · #4 05-12-2016, 12:59 AM

Quote:

Originally Posted by vince692

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.

vince692 · #5 05-12-2016, 01:21 AM

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

macropod · #6 05-12-2016, 04:36 AM

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???

vince692 · #7 05-12-2016, 06:44 AM

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...

macropod · #8 05-12-2016, 02:06 PM

I suggest you look at: https://support.microsoft.com/en-us/kb/212618

vince692 · #9 05-13-2016, 12:34 AM

Thank you !

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