Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be like:
ActiveDocument.Evaluate("=Count({<Currency={USD}>}Currency)")
May be like:
ActiveDocument.Evaluate("=Count({<Currency={USD}>}Currency)")
one correction should be Currency={'USD'}
If your string is not separated by space ,quotes are optional. Therefore USD would work without quotes as well.