API for Excel VBA

Hi All

Does any one know of an API which can help me with this thread...

http://vbforums.com/showthread.php?t=459369

Check this out - appears to be an API only solution:

http://groups.google.ca/group/micros...+basic&rnum=2#