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

  • Thread starter Thread starter Pat
  • Start date Start date
P

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
 
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
Click to expand...

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.
 
Back
Top