Do you need to open an instance of Excel to use its worksheet functions. I
know very little about VB but this worked for me:

with a reference to Excel in Project References

Private Sub Command1_Click()

Dim xlFun As Excel.WorksheetFunction
Set xlFun = Excel.WorksheetFunction

x = xlFun.TDist(1.96, 60, 2)

MsgBox x
End Sub

Regards,
Peter T


Are there any pure VB functions that have the functionality of Excel's
TDist, TInv, NormSDist, etc functions? The reason is that i do not
want to have to have an instance of Excel open whenever i want to use
these functions in Access, Word, VB6, etc.

Any help would be appreciated.