[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 579
  • Last Modified:

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

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
MatjazRak
Asked:
MatjazRak
  • 2
1 Solution
 
MirkwoodCommented:
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
 
MatjazRakAuthor Commented:
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
 
MirkwoodCommented:
msvb50.dll

Try filemon!!!!!
0
 
cadlerCommented:
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now