searching for a quote in VB
Posted on 2010-11-30
I have a text like the following
ShowMessage("Hello World", "abc")
I try to extract the 'Hello World' text message out in VBA if I see it is a function ShowMessage. Of course that can be a space before and after '('.
I have right up a function to examine the function name, then open bracket, and then try to search for the double quote. What I notice that the Mid(string, 1, 1) function will return me 'H' whether my string is "Hello" or Hello.
Is there any way I can search for double quote.
Or some other mean to extract the text message.