API Call to extract data from Excell sheet

I want to retrieve cell values from an open Excell sheet using API Calls.

Please help!

You wouldn't normally use the API, since Excel exposes a number of COM objects.

This may help: http://www.mindspring.com/~tflynn/excelvba.html