I am trying to run an Excel statistical formula in Access using VBA. Help in VBA says you can do this, but they do not give the syntax for running a formula. I already have the formula working properly in Excel, so I know how to feed the formula, just not how to run an Excel formula in VBA. Any thoughts?
Yes, I am referencing the Excel Object Library.