Find out the number of count in a feild for a specific value

[#1]

So far I am using the following:

ActiveDocument.Evaluate("=GetSelectedCount(Currency)") -> to find out the number of count for 'Currency' field

ActiveDocument.Fields("Currency").Select "USD" -> to select the 'Currency' field with value 'USD'

However, I 'don't want to make any selection', I just want to find out the number of count of 'USD' in 'Currency' field, what is the VBA syntax would be?

[tresesco · Accepted solution]

May be like:

ActiveDocument.Evaluate("=Count({<Currency={USD}>}Currency)")

[#3]

one correction should be Currency={'USD'}

[tresesco]

If your string is not separated by space ,quotes are optional. Therefore USD would work without quotes as well.