Milewskp
asked on
How to search for strings in VBA Ccode
How can I use VBA Code to check for the string:
Const ThisProcName as string = "XXX"
in every procedure of every module of my mdb, and return the name of the first module/ procedure that doesn't have it?
NOTE: 'XXX' is the name of each procedure.
Const ThisProcName as string = "XXX"
in every procedure of every module of my mdb, and return the name of the first module/ procedure that doesn't have it?
NOTE: 'XXX' is the name of each procedure.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks Chris,
That's what I was looking for. Great link too!
That's what I was looking for. Great link too!
ASKER
<what are you trying to do ... searh every module and every sub in each module to make sure the string "XXX" is referenced in the subs? If so I assume you include functions in the scenario?>
Yes, every procedure, including subs, functions and event procedures.