Solved

Cannot insert a common control dialog box in Excel'97

Posted on 1998-12-01
4
1,037 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

My experience with Windows 10 over a one year period and suggestions for smooth operation
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Learn how to create and modify your own paragraph styles in Microsoft Word. This can be helpful when wanting to make consistently referenced styles throughout a document or template.

690 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