View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error

Hi Lakshimi,


Unfortunately, you do not provide the next
linewhich describes the automation error.

However, the error may relate to an Oracle
privileges issue.

As you are using late binding, you do not need
to set references.



---
Regards.
Norman


wrote in message
...
Hi,

I get this error while running a report in Excel VBA 2003,

my code is

Dim OraSession As Object
Set OraSession = CreateObject("OracleInProcServer.XOraSession")

Do i need to set any references for this? pls. help very urgent.
This report runs in few system.

Lakshmi