"After Googling around not quite finding what I wanted, I remembered the Edanmo site which got me thinking about TLBINF32.DLL, downloading Microsoft's TLBINF32.CHM and reading up on GetMembersWithSubStringEx.
Below is the implementation of it (done in VB6 with a reference to TLBINF32.DLL), some demo VBScript and output, and the wrapping of that functionality in some VBA.
VBScript demo. The above code was included in my StdLib DLL in the Registry coclass.
Output from the demo (script was run in SciTE).
Finally, the VBA code. A cell has a symbol in it and this routine finds it or returns an error string. (
reg.in this case refers to the Registry coclass in the StdLib.DLL)
Hmm ... no error checking. Should fix that.
© Copyright Bruce M. Axtens, 2009