Reference to Excel 10.0 Library

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   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

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
brit Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27 November 2006 Location: Korea, South Status: Offline Points: 6	Post Options Post Reply Quote brit Report Post Thanks(0) Quote Reply Topic: Reference to Excel 10.0 Library 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

brit Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 27 November 2006 Location: Korea, South Status: Offline Points: 6	Post Options Post Reply Quote brit Report Post Thanks(0) Quote Reply 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