This topic might be not new, but I've been searching for days and still couldn't find a solution to my problem, so I wanted to post it here - much appreciate if you could help:
I developed an Excel VBA application for my client, in which I used the Microsoft ListView Control (MS Windows Common Controls 6.0 SP6). It is included in the library MSCOMCTL.ocx (see screenshot below):
My problem: the file runs perfectly on my computer (Windows 10, Office 365 64Bit), but when I sent it to my client (Windows 10, Office 2016 MSO version 16.0.4266.1001, 64 Bit, installed using MSI package), the following error popped up when the Userform is run:
When opening the VBE of the client, we see that the library is missing:
We then tried following different options, but without success:
Install the missing mscomctl.ocx with the MS download link:
-> did not work
Copy the "mscomctl.ocx", which is extracted from the file downloaded in the link above, to C:\Windows\SysWow64 of the client, and then register the "mscomctl.ocx" using Cmd or Powershell (run as Administration) and the command
-> now the reference is not shown as "MISSING" anymore, but the error "Could not load an object because it is not available on this machine" still occurrs.
-> still did not work.
I then found this which is posted in 2017:
and I'm not sure whether it is still up-to-date (whether the MSCOMCTL.OCX still does not support Office 2016 MSI 64 Bit).
Would be very thankful if anyone of you know a solution.
Thanks and best regards,