PC Review


Reply
Thread Tools Rate Thread

DocProps - driving me crazy!

 
 
Summer
Guest
Posts: n/a
 
      29th Sep 2007
Hi,

I’m blank! Is it possible to write a toggle macro to toggle through 4 options for a DOCPROPERTY where the value is m or f or p or n = Mr or Mrs or Mr & Mrs or Blank



I thought maybe I could set Gender = m OR f OR p OR n using a macro? I use male female plural neuter as my options – so I need a macro that can toggle also as well as a field nest that works:



This is simple with Male or Female but I am trying to expand on this:



{IF {DOCPROPERTY Gender \ * MERGEFORMAT } = male Mr Ms \* MERGEFORMAT }



I need to add Male or Female or Plural or Neuter



So far I have this field nesting:



{DOCPROPERTY “gender” \ MERGEFORMAT }

{IF { = AND({ IF {DOCPROPERTY “gender” } = “male” 1 0 }, { IF {DOCPROPERTY “gender” } = “neuter” 1 0 }) } = 1 “Mr” “Mr & Mrs” \ *MERGEFORMAT }

Any ideas anyone please?

 
Reply With Quote
 
 
 
 
Graham Mayor
Guest
Posts: n/a
 
      29th Sep 2007
I would probably do something along the lines of

Dim sGender As String
Start:
sGender = InputBox("Enter gender letter = m, f, p, n", "Gender")
If UCase(sGender) <> "M" And UCase(sGender) <> "F" _
And UCase(sGender) <> "P" And UCase(sGender) <> "N" Then
MsgBox "Enter correct letter!", vbCritical
GoTo Start:
End If
Select Case LCase(sGender)
Case Is = "m"
sGender = "Mr."
Case Is = "f"
sGender = "Ms."
Case Is = "p"
sGender = "Mr. & Mrs."
Case Is = "n"
sGender = "neuter"
Case Else
'Do nothing
End Select
ActiveDocument.CustomDocumentProperties("Gender").Value = sGender
ActiveDocument.Fields.Update

which will write the required string to the pre-existing DocProperty field Gender. You can then use the field {DocProperty Gender} in the document. The macro will update the field to show the correct result.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



"Summer" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
Hi,

I’m blank! Is it possible to write a toggle macro to toggle through 4 options for a DOCPROPERTY where the value is m or f or p or n = Mr or Mrs or Mr & Mrs or Blank



I thought maybe I could set Gender = m OR f OR p OR n using a macro? I use male female plural neuter as my options – so I need a macro that can toggle also as well as a field nest that works:



This is simple with Male or Female but I am trying to expand on this:



{IF {DOCPROPERTY Gender \ * MERGEFORMAT } = male Mr Ms \* MERGEFORMAT }



I need to add Male or Female or Plural or Neuter



So far I have this field nesting:



{DOCPROPERTY “gender” \ MERGEFORMAT }

{IF { = AND({ IF {DOCPROPERTY “gender” } = “male” 1 0 }, { IF {DOCPROPERTY “gender” } = “neuter” 1 0 }) } = 1 “Mr” “Mr & Mrs” \ *MERGEFORMAT }

Any ideas anyone please?

 
Reply With Quote
 
Klaus Linke
Guest
Posts: n/a
 
      29th Sep 2007
Hi Summer,

Instead of nesting fields and creating complicated constructs, maybe create
a bookmark "address" for how to address the person, and use something like
this to change the text of the bookmark:
{ IF { DOCPROPERTY "gender" } = "male" { Set address "Mr" } }
{ IF { DOCPROPERTY "gender" } = "female" { Set address "Mrs" } }
{ IF { DOCPROPERTY "gender" } = "neuter" { Set address "Mr & Mrs" } }

Regards,
Klaus


 
Reply With Quote
 
Summer
Guest
Posts: n/a
 
      30th Sep 2007
I'm going to try this now.. thank you...
"Graham Mayor" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
I would probably do something along the lines of

Dim sGender As String
Start:
sGender = InputBox("Enter gender letter = m, f, p, n", "Gender")
If UCase(sGender) <> "M" And UCase(sGender) <> "F" _
And UCase(sGender) <> "P" And UCase(sGender) <> "N" Then
MsgBox "Enter correct letter!", vbCritical
GoTo Start:
End If
Select Case LCase(sGender)
Case Is = "m"
sGender = "Mr."
Case Is = "f"
sGender = "Ms."
Case Is = "p"
sGender = "Mr. & Mrs."
Case Is = "n"
sGender = "neuter"
Case Else
'Do nothing
End Select
ActiveDocument.CustomDocumentProperties("Gender").Value = sGender
ActiveDocument.Fields.Update

which will write the required string to the pre-existing DocProperty field Gender. You can then use the field {DocProperty Gender} in the document. The macro will update the field to show the correct result.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>



"Summer" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
Hi,

I’m blank! Is it possible to write a toggle macro to toggle through 4 options for a DOCPROPERTY where the value is m or f or p or n = Mr or Mrs or Mr & Mrs or Blank



I thought maybe I could set Gender = m OR f OR p OR n using a macro? I use male female plural neuter as my options – so I need a macro that can toggle also as well as a field nest that works:



This is simple with Male or Female but I am trying to expand on this:



{IF {DOCPROPERTY Gender \ * MERGEFORMAT } = male Mr Ms \* MERGEFORMAT }



I need to add Male or Female or Plural or Neuter



So far I have this field nesting:



{DOCPROPERTY “gender” \ MERGEFORMAT }

{IF { = AND({ IF {DOCPROPERTY “gender” } = “male” 1 0 }, { IF {DOCPROPERTY “gender” } = “neuter” 1 0 }) } = 1 “Mr” “Mr & Mrs” \ *MERGEFORMAT }

Any ideas anyone please?

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
This is driving me crazy!! Dave Microsoft Access 1 16th Jan 2007 06:22 PM
This Is Driving Me Crazy Ron Windows XP Internet Explorer 2 11th Sep 2006 08:06 PM
MMS is driving me crazy =?Utf-8?B?bW1hZ2ljeg==?= Windows XP Messenger 1 18th May 2006 11:13 AM
please help this is driving me crazy =?Utf-8?B?bWVybGlu?= Windows XP General 4 29th Jul 2004 12:42 AM
Help This is driving me crazy Richard Microsoft Excel Worksheet Functions 1 11th Dec 2003 03:14 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:54 PM.