Can you add a excel funtion into access?? 1

[redsand23]

Here is my challenge. I need to use the normsinv function from excel in my access report to report sigma values. Is there a way to add in this function to access?

Thanks for any help!!!

 

[jebry]

Hi!

Someone answered this recently in tek-tips though I cannot remember who. The basic steps you need to take are:

1. In the code window select Tools/References and check the reference to Microsoft Excel.

2. In a module create a Public Function:

Public Function fnNormsInv(prob As Double, mean As Double, stddev As Double) As Double

Dim xlApp As New.ExcelApp

fnNormsInv = xlApp.Application.WorksheetFunction.normsinv(prob, mean, stddev)

Set xlApp = Nothing

End Function

You may need to open a workbook instead of an excel app but you can play with that.

3. Call the function from anywhere in your DB, including SQL and pass the function the appropriate parameters.

hth
Jeff Bridgham
bridgham@purdue.edu

 

[redsand23]

Thanks that is exactly what I needed!!