<div>
is your error code 214418107 (80010005) &nbsp;or 2147418107 (80010005)??? please clarify...<br />
<br />
vmano<br />
<br />

</div>


is your error code 214418107 (80010005)  or 2147418107 (80010005)??? please clarify...

vmano



<div>
Cheers mate<br />
I'll go have a look<br />
<br />
Matt<br />

</div>


<div>
<div class="content wysiwyg-content">
I'm using VB5 and Excel 97 under NT 4 &amp;&nbsp;OLE Automation (I'm using VB to populate cells on a worksheet), every thing works OK when the VB environment is running BUT I get Automation Error -214418107 (80010005) when I compile and run the EXE. I have tried putting MsgBox's in to trap where the error happens but it appears to be random.<br />
The manuals don't seam to help and On Error fails to trap this error.<br />
Can anyone help?<br />
TIA<br />
Matt
</div>
</div>


I'm using VB5 and Excel 97 under NT 4 & OLE Automation (I'm using VB to populate cells on a worksheet), every thing works OK when the VB environment is running BUT I get Automation Error -214418107 (80010005) when I compile and run the EXE. I have tried putting MsgBox's in to trap where the error happens but it appears to be random.
The manuals don't seam to help and On Error fails to trap this error.
Can anyone help?
TIA
Matt

Automation error with Excel

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.