Solved

Cannot insert a common control dialog box in Excel'97

Posted on 1998-12-01
4
1,023 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
Comment Utility
Edited text of question
0
 
LVL 1

Accepted Solution

by:
moosach earned 200 total points
Comment Utility
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
Comment Utility
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
Comment Utility
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

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Article by: dandraka
There are several quick shortcuts that can make your life easier in Microsoft Programs.  These simple tips and tricks will your work more productive and you faster at completing your tasks! MS Word (1) Creating Re-usable Scraps You can create s…
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

744 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

10 Experts available now in Live!

Get 1:1 Help Now