Paul,
You could check if the single line had a "Declare " and a " Lib " (note the
spaces) and compare text sensitive. Whilst not 100% conclusive, it would be
a pretty strange string to have both exactly like that.
Depending what you're after, maybe check it's not a comment first.

NickHK

"Paul Martin" wrote in message
ups.com...
Thanks all for your responses.

I'm using the Find method of CodeModule using the WholeWord argument as
True, so there's no problem capturing the various search criteria, and
this is very efficient. I was wondering if there's some way that VBA
(or an API) would recognise the use of the word as a reserved word or
otherwise.

Based on the responses I've received, the answer appears to be no. All
the solutions are based on capturing a code line as a string.


Dave Peterson wrote:

Can you look for it at the beginning of the line--after you trim any
leading
spaces (and ignoring Public/Private key words)?

And I think you'd have to make sure a space character followed it.

And you may have to count quotes to see if you're in a string.

Dim myStr as string
mystr = "Do you have anything to" & _
" declare"





Paul Martin wrote:

Hi all

I am writing some code that searches a VBA project for (in this case)
APIs and I am using "Declare" as the search criteria. If I find
"Declare", is there some way (perhaps an API) that can ascertain
whether the use of "Declare" is a string or a reserved word?

Now, I realise that if it is an API, it would be followed by
"Function"
or "Sub". I have other search criteria that I also need to look for
(such as "Shell" and ".RegisterDatabase").

Any suggestions appreciated. Thanks in advance.

Paul Martin
Melbourne, Australia

--

Dave Peterson