How do you in VBA find the string between two characters in a field? For example I have a field that is xxxxxxxxxxxxxxx(yyyyyy)zzzzzz. The only constant is the open and close parenthesis in the field (no constant character position in the field). What I need is to find the string between the two parenthesis 'yyyyyy'. How do you do this?