Solved

Redistributing Excel'97 application that is using COMCTL32.OCX TreeView control

Posted on 1998-11-02
4
511 Views
Last Modified: 2013-12-26
Hi Experts,
I designed an application in Excel '97 that is using TreeView controle. When I move the .xls file to another computer and when I press the button to load the TreeView form, I get the message:

ActiveX object not found!
and
Approppriate licence information not found on this machine.

I registered the ocx with regsvr32 and I also installed COMCTL32 update (401COMUPD.exe) but nothing helps.

What would be the best way to redistribute such application?

Thank you for the ansver?

Matjaz Rak

Matjaz.Rak@Skb.Si
0
Comment
Question by:MatjazRak
  • 2
4 Comments
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1488080
You are missing the common control OCX files most likely. But really, you are distributing an Excel document as application. You almost need an installation program to install it.

You can take a look with Filemon (www.sysinternals.com) to see what DLL and OCX are used and copy them to the remote machine.
0
 

Author Comment

by:MatjazRak
ID: 1488081
Dear Mirkwood,

thank you for your answer, but the needed files are already on the machine (ComCtl32.ocx, ComCtl32.dll, ComCtl32.oca, ComCtlLib.twd). I also registered .ocx file, but the error still existed.

Best regards,

Matjaz Rak

Matjaz.Rak@Skb.Si
0
 
LVL 13

Expert Comment

by:Mirkwood
ID: 1488082
msvb50.dll

Try filemon!!!!!
0
 
LVL 1

Accepted Solution

by:
cadler earned 200 total points
ID: 1488083
When you install Visual basic it installs the OCX files, plus it installs license information in the registry that allows the control to be used in the design environment. I don't think you're operating in that mode when running in VBA inside of Excel, which means you can't use that control on that machine, short of installing Visual basic on the machine.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

Suggested Solutions

Title # Comments Views Activity
passing a value with stream reader AFTER a ";" 3 74
Recommendation vb6 to vb.net or others 14 175
transition to visual .net from vb6 5 37
Set WorkSheet  not Working 9 38
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…

839 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