I'm getting a Compile error: Can't find project of libray.
and the "Dim objExcel As Excel.Application" is highlighted for a second the the:
Public Function GetXLStDev(No1 As Double, No2 As Double, No3 As Double) As Double
I tried this, and added it to a new Module, because the other one doesnt let me chose References - I have also attached the database if you woudl like to see that.
I'm using MS access 2003
From Microsoft:
To resolve this issue, on the computer that has MDAC 2.5 installed, click to clear the Microsoft Jet and Replication Objects 2.6 Library check box, and then add a reference to the Microsoft Jet and Replication Objects 2.5 Library. To do so, follow these steps:
Open the Visual Basic Environment (VBE).
On the Tools menu, click References.
At this point, you receive the following error message:
Your Microsoft Access Database or project contains a missing or broken reference to the file 'msjro.dll' version 2.6.
Click OK.
Click to clear the item in the References list that appears as, "MISSING: Microsoft Jet and Replication Objects 2.6 Library."
Click OK.
On the Tools menu, click References.
In the list of available references, click to select the Microsoft Jet and Replication Objects 2.5 Library check box, and then click OK.
Thanks for your help
and the "Dim objExcel As Excel.Application" is highlighted for a second the the:
Public Function GetXLStDev(No1 As Double, No2 As Double, No3 As Double) As Double
I tried this, and added it to a new Module, because the other one doesnt let me chose References - I have also attached the database if you woudl like to see that.
I'm using MS access 2003
From Microsoft:
To resolve this issue, on the computer that has MDAC 2.5 installed, click to clear the Microsoft Jet and Replication Objects 2.6 Library check box, and then add a reference to the Microsoft Jet and Replication Objects 2.5 Library. To do so, follow these steps:
Open the Visual Basic Environment (VBE).
On the Tools menu, click References.
At this point, you receive the following error message:
Your Microsoft Access Database or project contains a missing or broken reference to the file 'msjro.dll' version 2.6.
Click OK.
Click to clear the item in the References list that appears as, "MISSING: Microsoft Jet and Replication Objects 2.6 Library."
Click OK.
On the Tools menu, click References.
In the list of available references, click to select the Microsoft Jet and Replication Objects 2.5 Library check box, and then click OK.
Code:
Public Function GetXLStDev(No1 As Double, No2 As Double, No3 As Double) As Double
Dim objExcel As Excel.Application
Set objExcel = New Excel.Application
Pause 1
Let GetXLStDev = objExcel.StDev(No1, No2, No3)
objExcel.Quit
Set objExcel = Nothing
End Function
Public Function Pause(PauseSeconds As Double)
Dim Start
Start = Timer
Do While Timer < Start + PauseSeconds
DoEvents
Loop
End Function