Hmm. I did have that wrong.

Ok. You can get the references in parentheses with the subroutine we've been working on.

It can be tricky to get the country names, because the country names may not be uniform. You could have "Brazil" in one spot, and an official name like "Federative Republic of Brazil" in another.

Nevertheless, I played around with this a bit, and came up with something. I tried to keep it simple enough that you could try it out. However, it is quite long, so I'm including as an attachment.

By the way, you have to paste this at the top of a module. The User-Defined Type has to be placed there.

Again, hope this is helpful.

Attached Files

FindCountriesInDocument.txt (7.3 KB, 23 views)