View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Urgent!!! Run-time error '-2147024770 (8007007e)' Automation error

You're using late binding, so you should not need to set a reference.
Is the Oracle package installed on the client ?

Tim

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