Using OLE Auto

Can someone help me understand the mechanics of using OLE Auto. I am trying to understand how I find the methods for each application that I wish to communicate with. Ther are several enumeration methods I can use in Paradox that give me information about the available servers. I would like to be able to understand how i can manipulate Excel. Where do I find how to initiate the communication. After initiating where do I find documentation to open a file, go to a cell, etc. I have used OLE Auto only in a very simple way and would like to unsderstand it better.

seems paradox is a dying breed.  There is an example link to a sample lsl (library). gives you all you need to get and set values, select specific files and worksheets.  I have also been unsuccessful in finding a full library of methods or samples. look up Vladimir Menkin. nice library, but I know it doesn't give everything.