Docking Pane - Reference to Excel 10.0 Library

Print Page | Close Window

Reference to Excel 10.0 Library

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Docking Pane
Forum Description: Topics Related to Codejock Docking Pane
URL: http://forum.codejock.com/forum_posts.asp?TID=5622
Printed Date: 31 January 2025 at 2:57pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Reference to Excel 10.0 Library

Posted By: brit
Subject: Reference to Excel 10.0 Library
Date 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!!

Replies:

Posted By: brit
Date 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! ^^