Help : VB 6.0 and Excel 8.0 / OLE 'runtime Error 429'

[Fabrice Courtois]

Hello,

I have this recurrent problem in instanciating an Excel application in
my VB code on one computer.
Whatever the code I use, I get :
"Runtime error 429
ActiveX can't create object..."
Here is the code :

The reference to 'Microsoft Excel 8.0 Object Library' is set.

Public ExcelApp As Object
...
sub UseExcel()
Set ExcelApp = New Excel.Application 'Error
...
I tried this also :

Public ExcelApp As Object
...
sub UseExcel()
Set ExcelApp = CreateObject("Excel.Application")
Set ExcelApp = GetObject("", "Excel.Application")

This problem occures on one computer only, I tried on another one and
it works fine.
Both have the same configuration :
NT 4.0 SP4 (french)
VB 6.0 (french) (same version on both)
MS-Office Pro (french) (don't know)

I understand it's a registration problem, I tried to reinstall Office
and even VB but ... nothing to do
I've contacted some people who had the same problem, but noway.., the
same final answer was "I'm using another computer now"...

So, please help, I can still use another computer, but the final
user ??

Thanks a lot

[eric...@my-deja.com]

hello..about your problem, have u used the OLE control to link the
excel with your application...
If u used Ole control there won't be problem ...
Hope that will help u..
bye
In article <3795961D...@pg2m.com>,

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.

[Fabrice Courtois]

Thank's for answering so quick but...

Well, I just tried and got this error (translated from french...) when I
selected the "Excel Sheet "

"System error &H80080005 (-2146959355) Server execution failed"

What does it mean ???
Is this an Ole version problem, an Ole registration pb ??
Or (again) an Excel version or regsitration problem... ?!?!?!

I've checked MSDN Help and their was nothing really meanfull except to look
in the Event Viewer
where I saw :
(translated:)
<
DCOM Server : {00024500-0000-0000-C000-000000000046} startup is not
possible.
the error :
" %1 is not a Windows NT valid application"
happend when starting the command :
C:\Program Files\Microsoft Office\Office\excel.exe /automation -Embedding
>
in french :
<
Le démarrage d'un serveur DCOM : {00024500-0000-0000-C000-000000000046}
n'est pas possible. L'erreur :
"%1 n'est pas une application Windows NT valide. "
a eu lieu au démarrage de la commande :
C:\Program Files\Microsoft Office\Office\excel.exe /automation -Embedding
>

Then I tried to put brackets to the localServer32 command line mentionned:
{00024500-0000-0000-C000-000000000046}
localServer32
"C:\Program Files\Microsoft Office\Office\excel.exe"

and the OLE Control just says that "the component is not correctly
installed"

I can't figure out what could happend know,
if somebody have a clue, please let me know

[Patrice LESCAUT]

Fabrice,

 

J'ai eu des problème pour compiler et exploiter des ActiveX avec VB5 et le SP3 en Français ...

Le problème a été résolu en travaillant sur une version anglaise de VB5 (idem pour le 6), à ce propos, Microsoft n'avait par obtenu le droit d'utiliser des pilotes SQL server pour Crystal Report 4.6 en français. Je n'ai pu utiliser CR et SQL Server qu'avec une version US.

 

Je ne réponds pas à tes question mais je veux juste te signaler que des problèmes "étranges" existent entre les langues de traduction des versions ...

 

Bonne chance ...

 

Patrice

 

Fabrice Courtois a écrit dans le message <3795961D...@pg2m.com>...

[B Mannikko]

Microsoft documents a problem with NT, Office 97 and 2000, and VB.
Check this URL:
http://support.microsoft.com/support/kb/articles/Q185/1/26.ASP

Good luck

Fabrice Courtois <fcou...@pg2m.com> wrote in message
news:3795961D...@pg2m.com...

[ADP]

i18n.  Quel surprise!

 

--A

Patrice LESCAUT wrote in message <7n4k59$r4t$1...@wanadoo.fr>...

[Fabrice Courtois]

Hi,
That was the solution, I should have thought about it with the event
viewer message.
Thank you, you saved some days waiting for a free computer.. !

I quoted from the page for other users, here is the quote which is IT :

"... To edit the registry, run the RegEdit.exe utility. The LocalServer32
key for your ActiveX server will be located in the HKEY_CLASSES_ROOT\CLSID
section of the registry.

To locate the LocalServer32 key for your ActiveX server, choose Find
from the Edit menu and specify the file name of your ActiveX server (or
search on the ProgID). For example, to find the LocalServer32 key for
Microsoft Excel, search for "Excel.exe." You might need to press F3 to Find
Next until you see the
LocalServer32 key. For the case of Microsoft Excel, the LocalServer32
value might be:

C:\Program Files\Microsoft Office\Office\excel.exe /automation

Assuming that the short path is C:\Progra~1\Micros~1\Office, you can
change the LocalServer32 value to:

C:\Progra~1\Micros~1\Office\excel.exe /automation

You should only have to change one LocalServer32 key for your ActiveX
server. To determine exactly what to specify for the short path, check the
properties
of the ActiveX server file in the Windows Explorer. See the MS- DOS name
setting in the Properties window. Also check the properties of the folder in
which
the ActiveX server resides so that you can determine the complete short
path of your ActiveX server.
..."

Thank you again !!!

B Mannikko wrote:

> Microsoft documents a problem with NT, Office 97 and 2000, and VB.
> Check this URL:
> http://support.microsoft.com/support/kb/articles/Q185/1/26.ASP
>
> Good luck
>
> Fabrice Courtois <fcou...@pg2m.com> wrote in message
> news:3795961D...@pg2m.com...

> > Hello,
> >
> > I have this recurrent problem in instanciating an Excel application in
> > my VB code on one computer.
> > Whatever the code I use, I get :
> > "Runtime error 429
> > ActiveX can't create object..."
> > Here is the code :

> > ...
> > Thanks a lot
> >
> >
> >