pull data from Access into Excel VBA function, return answer to Excel

[Pat]

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

 

[pietlinden]

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.