using an excel database function in Visual Basic
 

How do I property invoke/use an excel database function like dsum in a visual
basic sub?

why can't I just set

x = dsum(tablerange,"fieldname",criterianame)

How do I declare this existing function? I am new to this.
--
Please contact me by email if you have an answer to this question. I
appreciate it.