pull data from Access into Excel VBA function, return answer to Excel - ADO DAO RDO RDS

On Jul 17, 4:57 pm, Pat <patrickmo...@yahoo.com> wrote:
> Hi,
> I am working through the O'Reilly book Integrating Access and Excel.
> I have a table in Access with 3 columns, a stock ID, a date, and a %
> return.
> I want to write a sub procedure that will calculate the mean and
> standard deviation of each stock, and output the ratio of these into
> Excel. Does anyone know how to do that?
> Thanks,
> Pat

why not query the Access table from Excel and then just use the built-
in STDEV(), AVERAGE() functions? Doing this from Access would be a
total PITA.