Call an Excel Function from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've attempted to do some research on this but land up in the sections of the
book(s) that deal with programming (which I am not yet there) so I look for
your help at MS Discussion.

There are two fields that I would like to include on this one specific
report which call for the calculation of the Average and the Median
(statistical functions).

I have heard it said that all I have to do is call the Excel worksheet
function from Access ... 'you must have a reference set to excel or late bind
to excel as these worksheet functions are called from excel ...
'worksheetfunction.Excelfunctionname AnyParametersneeded'.

That's still unclear to me. I am such a newbie at creating modules etc.
that I need more tutoring on this in order to make it happen.

Can anyone help?
 
Steve

The book tells you that use of references involves programming. You post in
a "programming"-related newsgroup. But you want a non-programming
explanation?! <g>

To use the Excel function, after you've set a reference to it in Access,
you'll need to 'ken' some programming. To set the reference, create a new
module, click Tools|References, and locate the line that has your version of
MS Excel. Check the box and Save/close. Your mdb now has a reference to
the Excel object model, including the Median function.

By the way, Access does have an "Average" function, as part of its Totals
query -- but it does expect to have normalized data to work on.
 
ouch! it seems i know less of the topic than i originally thought. thank you
none-the-less for offering some insight into this new area of learning for
me. i hope you have a pleasant day.

Jeff Boyce said:
Steve

The book tells you that use of references involves programming. You post in
a "programming"-related newsgroup. But you want a non-programming
explanation?! <g>

To use the Excel function, after you've set a reference to it in Access,
you'll need to 'ken' some programming. To set the reference, create a new
module, click Tools|References, and locate the line that has your version of
MS Excel. Check the box and Save/close. Your mdb now has a reference to
the Excel object model, including the Median function.

By the way, Access does have an "Average" function, as part of its Totals
query -- but it does expect to have normalized data to work on.
Click to expand...
 
Back
Top