urgent!!!!!

[Nparag]

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

[croylejj]

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