Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default I need to use CreateObject("OracleInProcServer.XOraSession")

I try to use the... Set OraSession =
CreateObject("OracleInProcServer.XOraSession"), so I see the message: ActiveX
component can't create object (Run-time error 429). What do I do?
Looks like missing any References of VBA.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 62
Default I need to use CreateObject("OracleInProcServer.XOraSession")

I'm thinking you need to add a reference to the object library. In the vba
editor, from the menu, choose Tools References. Then find the Oracle
library you need and check the check box next to it.

Hope this helps.

Keith

"Falango" wrote:

I try to use the... Set OraSession =
CreateObject("OracleInProcServer.XOraSession"), so I see the message: ActiveX
component can't create object (Run-time error 429). What do I do?
Looks like missing any References of VBA.

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default I need to use CreateObject("OracleInProcServer.XOraSession")

I agree, but I tried some References.. so didn't do... do you know what
References I need?

Thanks a lot
Falango

"Keithlo" wrote:

I'm thinking you need to add a reference to the object library. In the vba
editor, from the menu, choose Tools References. Then find the Oracle
library you need and check the check box next to it.

Hope this helps.

Keith

"Falango" wrote:

I try to use the... Set OraSession =
CreateObject("OracleInProcServer.XOraSession"), so I see the message: ActiveX
component can't create object (Run-time error 429). What do I do?
Looks like missing any References of VBA.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I get the author of a file using CreateObject("Scripting.FileSystemObject")? Excel 009 Excel Programming 8 November 3rd 06 08:32 PM
Set OutApp = CreateObject("Outlook.Application") - Runtime error 429 Buffyslay Excel Programming 2 July 20th 05 05:06 PM
ASP: CreateObject("Excel.Application") IIS 6.0 Win2003 Mau[_2_] Excel Programming 0 July 20th 05 11:45 AM
Excel:Runtime Error 7 "Not enough Memory" with CreateObject (SAP.B sebastienm Excel Programming 0 July 24th 04 08:35 AM
CreateObject("Excel.Application") - Access denied Luca[_2_] Excel Programming 0 February 6th 04 01:21 PM


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"