Solved

Cannot insert a common control dialog box in Excel'97

Posted on 1998-12-01
4
1,030 Views
Last Modified: 2012-06-27
An error message stated " Cannot insert object" occurs in Excel'97 worksheet when i try to place a Common Control Dialog Box  fromthe visual basic toolbox. However, after i have installed visual basic 5.0, no problems occur.  is there any way to solve this problem without installing visual basic 5.0
0
Comment
Question by:loyweemin
  • 2
  • 2
4 Comments
 

Author Comment

by:loyweemin
ID: 1614764
Edited text of question
0
 
LVL 1

Accepted Solution

by:
moosach earned 200 total points
ID: 1614765
Hi,

I feel you have bad luck. Check the MS knowledgebase article below. It states that there is only a very limited number of controls possible and tested. Most of the other ones produces the mentioned error. Reason is the lack of an OLE interface.

Hope this answers your question.

Toni

................................................

XL97: Error Inserting ActiveX Object in a Worksheet

PSS ID Number: Q165450
Article last modified on 02-12-1998
 
WINDOWS:97
 
WINDOWS
 

======================================================================
---------------------------------------------------------------------
The information in this article applies to:
 
 - Microsoft Excel 97 for Windows
---------------------------------------------------------------------
 
SYMPTOMS
========
 
When you insert an ActiveX control onto a Microsoft Excel worksheet, you
may receive the following error message:
 
   Cannot insert object
 
CAUSE
=====
 
You receive this error message if the ActiveX control that you are
inserting does not support the IDataObject OLE interface.
 
STATUS
======
 
This behavior is by design of Microsoft Excel 97.
 
MORE INFORMATION
================
 
You can insert an ActiveX control onto a Microsoft Excel worksheet using the Control Toolbox toolbar. By default, only the controls in the Fm20.dll file that ships with Microsoft Office are available on the Control Toolbox toolbar. Clicking More Controls on the Control Toolbox toolbar displays a
list of other ActiveX controls that are registered on your computer.
 
The following ActiveX controls are installed with Microsoft Excel 97. These controls are the only ActiveX controls that are fully tested and supported for use with Microsoft Excel.
 
 ActiveX
 Control Name          Installed with                          File Name
 -----------------------------------------------------------------------
 
 Check Box             Microsoft Office 97                     Fm20.dll
 Text Box              Microsoft Office 97                     Fm20.dll
 Command Button        Microsoft Office 97                     Fm20.dll
 Option Button         Microsoft Office 97                     Fm20.dll
 List Box              Microsoft Office 97                     Fm20.dll
 Combo Box             Microsoft Office 97                     Fm20.dll
 Toggle Button         Microsoft Office 97                     Fm20.dll
 Spin Button           Microsoft Office 97                     Fm20.dll
 Scroll Bar            Microsoft Office 97                     Fm20.dll
 Label                 Microsoft Office 97                     Fm20.dll
 Image                 Microsoft Office 97                     Fm20.dll
 
You can insert the following ActiveX controls onto a Microsoft Excel worksheet without receiving an error message. However, these ActiveX controls have not been tested for use on Microsoft Excel worksheets. These controls may not be fully functional.
 
 ActiveX
 Control Name          Installed with                          File Name
 --------------------------------------------------------------------------
 
 Calendar Control     Microsoft Office 97                     Mscal.ocx
 Web Browser Control  Microsoft Office 97 ValuPack            Shdocvw.dll
 MsComm Control       Microsoft Visual Basic 5.0 Professional Mscomm32.ocx
 MAPIMessages Control Microsoft Visual Basic 5.0 Professional Msmapi32.ocx
 MAPISessions Control Microsoft Visual Basic 5.0 Professional Msmapi32.ocx
 Masked Edit Control  Microsoft Visual Basic 5.0 Professional Msmask32.ocx
 Picture Clip Control Microsoft Visual Basic 5.0 Professional Piclclp32.ocx
 
NOTE: Other ActiveX controls that exhibit the behavior discussed in this article may be installed on your computer. These controls are not listed in the table.
 
When you insert the following ActiveX controls on a Microsoft Excel worksheet, you receive the error message in this article.
 
 ActiveX
 Control Name        Installed with                           File Name
 -------------------------------------------------------------------------
 
 Animation Control   Microsoft Office 97, Developer Edition   Comct232.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 Common Dialog
 Control             Microsoft Office 97, Developer Edition   Comdlg32.ocx
 
 ImageList Control   Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 ListView Control    Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 Rich Textbox
 Control             Microsoft Office 97, Developer Edition   Richtx32.ocx
 
 MSInet Control      Microsoft Office 97, Developer Edition   Comctl32.ocx
 
 ProgressBar Control Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 Slider Control      Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 StatusBar Control   Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 TabStrip Control    Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 Toolbar Control     Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 TreeView Control    Microsoft Office 97, Developer Edition   Comctl32.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 UpDown Control      Microsoft Office 97, Developer Edition   Comct232.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 WinSock Control     Microsoft Office 97, Developer Edition   Mswinsck.ocx
                     Microsoft Visual Basic 5.0 Professional
 
 Internet Transfer   Microsoft Visual Basic 5.0 Professional  Msinet.ocx
 
 FlexGrid
 Control             Microsoft Visual Basic 5.0 Professional Msflexgrid.ocx
 
 RichText Control    Microsoft Visual Basic 5.0 Professional  Richtx32.ocx
 
 Tabbed Dialog
 Control             Microsoft Visual Basic 5.0 Professional  Tabctl32.ocx
 
 DBList Control      Microsoft Visual Basic 5.0 Professional  Dblist32.ocx
 
 DBGrid Control      Microsoft Visual Basic 5.0 Professional  Dbgrid32.ocx
 
NOTE: Other ActiveX controls that exhibit the behavior discussed in this
article may be installed on your computer. These controls are not listed in
the table.
 
REFERENCES
==========
 
For more information about inserting ActiveX controls, click the Index tab
in Microsoft Excel Help, type the following text
 
   activex controls, adding
 
and then double-click the selected text to go to the "Add buttons, check
boxes, or other controls to a worksheet" topic.
 
Additional query words: XL97 ocx ole active x
======================================================================
Keywords          : xlui kberrmsg kbinterop
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbprb
=============================================================================
Copyright Microsoft Corporation 1998.


 

0
 

Author Comment

by:loyweemin
ID: 1614766
When Visual Basic 5.0  is installed in my system (WinNT 4.0), there is no problems in inserting a Common Dialog Box onto the Excel'97 worksheets .  Do you know what are the neceesary files needed to be copied  and registered into  my system   if i want to use the Common Dialog Box in my Excel'97 worksheet  without installing VB 5.0.

Thank you.
0
 
LVL 1

Expert Comment

by:moosach
ID: 1614767
Mmmh, not really. I would advice to just create a simple form containing a common dialog box with VB 5.0 and use the VB setup wizzard to create an installable. Test it on a machine without VB. Then you should see which DLLs, OCXs are necessary. These ones should then be installed on the real target machine. Don't forget to register these beasts :-).
Hope that helps.
Toni
0

Featured Post

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In case Office 2010 has not been deployed in your environment, this article may be quite useful. In our office, we wanted a way to deploy Microsoft Office Professional Plus 2010 through an automated batch file via logon script. This article is docum…
Outlook Free & Paid Tools
This video shows and describes the main difference between both orientations in Microsoft Word. Viewers will understand when to use each orientation and how to get the most out of them.
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now