Hi,
i try to connect to oracle and also i add the references "Oracle In Proc Server 4.0 Type Library" but still i'm getting error - "The specified module could not be found"
[VBA]
Sub ConnectToOracle()
Dim objSession As Object
Dim objDatabase As Object
' Create a reference to the OO40 dll
Set objSession = CreateObject("OracleInProcServer.XOraSession")
' Create a reference to my database
Set objDatabase = objSession.opendatabase("Oracle", "scott/tiger", 0&)
End Sub
[/VBA]
thanks..