urgent!!!!!

Hi folks
if anybody has idea how do we call the excel functions from vb application. e.g. excel gives us sum of the selected range. the same function i want to call from my vb application so that i can give the range of values and the function will operate on that range and give me the result.

Thanx in advance

If you reference the Microsoft Excel 8.0 Object Library DLL you can access all of the inherit functions and objects within the Excel VBA environment

Hope I helped
JC

(For example:)
Excel.ActiveCell.Activate
Excel.Range
Excel.Rows.Summary