Codejock Developer Community : Reference to Excel 10.0 Library http://forum.codejock.com/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 28 Apr 2026 22:39:15 +0000 Mon, 27 Nov 2006 23:37:38 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.04 360 forum.codejock.com/RSS_post_feed.asp?TID=5622 <![CDATA[Codejock Developer Community]]> http://forum.codejock.com/forum_images/codejock-logo.gif http://forum.codejock.com/ <![CDATA[Reference to Excel 10.0 Library : Hi all (again) Sorry for this...]]> http://forum.codejock.com/forum_posts.asp?TID=5622&PID=17679&title=reference-to-excel-10-0-library#17679 Author: brit
Subject: 5622
Posted: 27 November 2006 at 11:37pm

Hi all (again)
 
Sorry for this message, I just noticed that the previous Post tackled the same issue, and included the fine solution on top of that
 
Topic closed! ^^
JM
]]> Mon, 27 Nov 2006 23:37:38 +0000 http://forum.codejock.com/forum_posts.asp?TID=5622&PID=17679&title=reference-to-excel-10-0-library#17679 <![CDATA[Reference to Excel 10.0 Library : Hi all I&#039;m currently testing...]]> http://forum.codejock.com/forum_posts.asp?TID=5622&PID=17678&title=reference-to-excel-10-0-library#17678 Author: brit
Subject: 5622
Posted: 27 November 2006 at 11:32pm

Hi all
 
I'm currently testing the Dockpane control, and have encountered some bug: I am using VB 6.0, and I need to call an excel file to store some data, print reports etc. For this, I need the reference to the Microsoft Excel 10.0 Object Library in my VB project. However, when I run the application, VB crashes with the following message
Run-Time error '12':
Type mismatch
 
The error points to the code for the loading of the form containing the DockPane object,
 
Private Sub Form_Load()
Dim D as Pane
Set D = Me.DockingPane1.CreatePane(4, 320, 60, DockRightOf, Nothing)
etc...
 
Any ideas for a workaround on this issue? What is causing this crash??
 
Thanks in advance!!
 
JM
]]> Mon, 27 Nov 2006 23:32:46 +0000 http://forum.codejock.com/forum_posts.asp?TID=5622&PID=17678&title=reference-to-excel-10-0-library#17678