Extracting Field Data Using VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Don - 27 Sep 2005 20:26 GMT

Once a document is open in VBA, is it possible to get the data associated
with named reference fields: For example the document has the following
field:

{ REF DocNum \h \* MERGEFORMAT }

How can I retrieve the value (i.e. 2005-West-11 in this case) using VBA?

Thanks!

Don

Reply to this Message

Jean-Guy Marcil - 27 Sep 2005 21:02 GMT

Don was telling us:
Don nous racontait que :

> Once a document is open in VBA, is it possible to get the data
> associated with named reference fields: For example the document has
[quoted text clipped - 4 lines]
> How can I retrieve the value (i.e. 2005-West-11 in this case) using
> VBA?

{ REF DocNum \h \* MERGEFORMAT }

refers to a bookmark named " DocNum"

So, in VBA, just get the value of the bookmark itself:

Dim MyBookValueStr As String
MyBookValueStr = ActiveDocument.Bookmarks("DocNum").Range.Text

If you need to extract "DocNum" from the REF field, lookup the Code property
of Fields in the VBA help.

Signature

Salut!
_______________________________________
Jean-Guy Marcil - Word MVP
jmarcilREMOVE@CAPSsympatico.caTHISTOO
Word MVP site: http://www.word.mvps.org

Reply to this Message

Don - 27 Sep 2005 22:01 GMT

Perfect! The Fields properties are especially helpful.

Thanks!!

Don

> Don was telling us:
> Don nous racontait que :
[quoted text clipped - 19 lines]
> If you need to extract "DocNum" from the REF field, lookup the Code
> property of Fields in the VBA help.

Reply to this Message