Need help with Excel Functions

[ulwitch]

The following is code that works in VBA that utilizes the Excel function "Median" from an Access module...

Dim objExcel As Excel.Application
Dim dTemp As Double

Set objExcel = New Excel.Application

dTemp = objExcel.Application.Median(1, 2, 5, 8, 13)

..................
I need to be able to reference a field of data from a table instead of hardcoding the values.

I saw how one person wrote their own function for getting the median, but I need to use other functions from Excel such as trimmean, skew, kurt, etc.

Can this be done?

 

[ggriffit]

check out

http://www.greggriffiths.org/webdev/both/excel/

which has some examples of the kind of things you want to do.