Median & Mode Calcuation (Con't)

E

ES

Hi. I know there is no build-in function to calculate the mode in Access 2002. I also saw there is a post regarding Median & mode calcuation. However, I followed the suggestions and check the "Microsoft Excel v.n Object Library" in VB Editior, but I do NOT see the code that I could copy and paste. Could anybody kindly help me? Thank you!
 
M

MGFoster

ES said:
Hi. I know there is no build-in function to calculate the mode in Access 2002. I also saw there is a post regarding Median & mode calcuation. However, I followed the suggestions and check the "Microsoft Excel v.n Object Library" in VB Editior, but I do NOT see the code that I could copy and paste. Could anybody kindly help me? Thank you!
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

There is no code that one can "copy & paste" just because you've
Referenced the Excel object model. You must reference the Excel object
in VBA in order to use it's methods/properties.

Read Access VBA Help articles on Automation; particularly anything on
Excel automation.

Hint: Dim appXL As Excel.Application

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQHSfioechKqOuFEgEQK+1ACdHEQKdLiqnnAU1A+K8fHwSrwvnE4AoJfa
cmGLwCudaPDXiQWYgET7rkXL
=JDLo
-----END PGP SIGNATURE-----
 
Top