Re: Oracle Objects for OLE & EXCEL

[Quoted] In article <7ajlup$eor$1_at_nnrp1.dejanews.com>,   duncan_at_dcl.co.uk wrote:
> I'm trying to use Oracle Objects for OLE with Excel V5.0
>
> I've installed it all but when I try the included example it falls over
> on the first CreateObject statement and clearly can't find OracleInProcServer.
>
> I've checked everything I can think of and all the docs, it appears it should
> work (hah) 'out of the box'.
>
> Has anyone used OO for OLE and Excel and got it working. Is there some subtle
> step that is missing from the install docs or something to do with Excel.
>
> Thanks
> Duncan
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

Excel should work the same as any other. First check that your \orant\bin directory is in your path. In this directory should be a file 'OIPx.DLL' (where x varies with the version number). Then run 'regsvr32 OIPx.DLL' This may fix your problems.

Regards,
Dave

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Feb 22 1999 - 00:46:13 CET