Type Mismatch error docking Pane

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

   The following code will always yield an error stating "Type Mismatch":
Dim PaneNew As Pane
Set Pane = Me.DockingPaneManager.CreatePane(FNP_DOCK_PANE, 200, 200, DockLeftOf, Nothing)
If I change the data type of PaneNew to a variant I receive no error. It appears to me the code I'm using should work and does on a older copy of the same code.
Is there something about this code that should be producing this error?

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Shawshank Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 16 October 2005 Status: Offline Points: 117	Post Options Post Reply Quote Shawshank Report Post Thanks(0) Quote Reply Topic: Type Mismatch error docking Pane Posted: 17 February 2006 at 1:51am
	The following code will always yield an error stating "Type Mismatch": Dim PaneNew As Pane Set Pane = Me.DockingPaneManager.CreatePane(FNP_DOCK_PANE, 200, 200, DockLeftOf, Nothing) If I change the data type of PaneNew to a variant I receive no error. It appears to me the code I'm using should work and does on a older copy of the same code. Is there something about this code that should be producing this error?

kylechen Members Profile Send Private Message Find Members Posts Add to Buddy List Groupie Joined: 29 November 2004 Status: Offline Points: 57	Post Options Post Reply Quote kylechen Report Post Thanks(0) Quote Reply Posted: 17 February 2006 at 2:16am
	Try Dim PaneNew As XtremeDockingPane.Pane

Shawshank Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 16 October 2005 Status: Offline Points: 117	Post Options Post Reply Quote Shawshank Report Post Thanks(0) Quote Reply Posted: 17 February 2006 at 9:05am
	That did the trick, thanks! I realized later after fighting with it that the error started after I added the Excel 11 object library which also contains a Pane object. Even when selecting both Pane objects the error would occur until a explicit reference, which you suggested, corrected the problem. Thanks!