Importing cell info from EXCEL

[shastri_s]

You can use DDE by setting the Linktopic, Linkitem and Linkmode properties.

Alternatively , you can use OLE Automation to achieve this.
With DDE,
Set Linktopic = excel|sheet1
linkitem = r1c1
linkmode = automatic

You can also dynamically change the linkitems to access diff. cells.

Hope this is useful