Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Statistical functions not tied to Application.WorksheetFunction
This is an excellent reference, Tom. Thanks a lot!
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help with Application.WorksheetFunction | Excel Discussion (Misc queries) | |||
Application.worksheetfunction | Excel Programming | |||
Application.WorksheetFunction.MMult | Excel Programming | |||
application.worksheetfunction.mmult help | Excel Programming | |||
Using Application.WorksheetFunction.Ln(...) in VBA | Excel Programming |