Excel retrieves data from Oracle
 

make sure that you actually do have that DLL installed &
registered.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi all, I would like to write a Excel macro program to
connect to Oracle
DB and retrieve data from it. I found from some websites
that I should
contain a sentance shown below in the source code:

Set OraSession = CreateObject
("OracleInProcServer.XOraSession")

However when I execute the program, it shows error 429
and said ActiveX
can't create object. Do I need to do anything so that I
can continue my
programming?

.

Excel retrieves data from Oracle
 

Hi, thanks for your reply first!

I am not very familiar with Macro and connection between Excel and
Oracle. Would you please tell me how I can get the DLLs and register
them, or provide any websites for my own learning?

Thanks again

Patrick Molloy wrote:

make sure that you actually do have that DLL installed &
registered.

Patrick Molloy
Microsoft Excel MVP
-----Original Message-----
Hi all, I would like to write a Excel macro program to
connect to Oracle
DB and retrieve data from it. I found from some websites
that I should
contain a sentance shown below in the source code:

Set OraSession = CreateObject
("OracleInProcServer.XOraSession")

However when I execute the program, it shows error 429
and said ActiveX
can't create object. Do I need to do anything so that I
can continue my
programming?

.