Call an Excel Function from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve D - 28 Feb 2005 10:59 GMT

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?

Signature

Thanks,
Steve D

Reply to this Message

Jeff Boyce - 28 Feb 2005 12:28 GMT

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.

Signature

Good luck

Jeff Boyce
<Access MVP>

> 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
[quoted text clipped - 13 lines]
>
> Can anyone help?

Reply to this Message

Steve D - 28 Feb 2005 13:47 GMT

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.

> Steve
>
[quoted text clipped - 31 lines]
> >
> > Can anyone help?

Reply to this Message