Solved

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

Posted on 1998-11-02
4
485 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help in WHSCRIPT 9 47
passing parameter in sql procedure 9 56
How to incorporate an error traping routing to existing code in VB6 11 39
VBA Shell can't Find Word document 11 75
I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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…

911 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

21 Experts available now in Live!

Get 1:1 Help Now