Link to home
Start Free TrialLog in
Avatar of loyweemin
loyweemin

asked on

Cannot insert a common control dialog box in Excel'97

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
Avatar of loyweemin
loyweemin

ASKER

Edited text of question
ASKER CERTIFIED SOLUTION
Avatar of moosach
moosach

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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.
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