Statistical functions not tied to Application.WorksheetFunction
 

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.

Statistical functions not tied to Application.WorksheetFunction
 

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.

Statistical functions not tied to Application.WorksheetFunction
 

Ignore previous, that does appear to open an instance of Excel which would
need Quit'ing and references set to nothing. Though seems a lot faster than
"New Excel.Application".

Regards,
Peter T


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.

Statistical functions not tied to Application.WorksheetFunction
 

Ignore previous, that does appear to open an instance of Excel which would
need Quit'ing and references set to nothing. Though seems a lot faster than
"New Excel.Application".

Regards,
Peter T


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.

Statistical functions not tied to Application.WorksheetFunction
 

Excel didn't invent statistics. There should be plenty of 3rd party sources
that supply such function libraries.

Here is a start:
http://members.aol.com/iandjmsmith/Examples.txt

--
Regards,
Tom Ogilvy



"R Avery" wrote in message
oups.com...
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.

Statistical functions not tied to Application.WorksheetFunction
 

This is an excellent reference, Tom. Thanks a lot!