View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.access
Paul Martin Paul Martin is offline
external usenet poster
 
Posts: 114
Default Ascertaining whether a search in VBA code returns a string or a reserved word

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