question

KimYongMin-5297 avatar image
1 Vote"
KimYongMin-5297 asked KimYongMin-5297 commented

VBA Excel 2016 MSI 64 Bit - Problem with ListView element (MSCOMCTL.OCX)

Dear community,

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):

Image

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:

Image

When opening the VBE of the client, we see that the library is missing:

Image

We then tried following different options, but without success:

  1. Install the missing mscomctl.ocx with the MS download link:

https://www.microsoft.com/en-us/download/details.aspx?id=10019

-> did not work

  1. 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 regsvr32 C:\Windows\SysWow64\mscomctl.ocx

-> 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:

https://social.technet.microsoft.com/Forums/en-US/b0cbd382-b556-4a5c-9e8e-9762343f9225/mscomctlocx-64bit-support-for-mso-version?forum=Office2016setupdeploy

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,

Kim




office-vba-devoffice-excel-itprooffice-itpro
image.png (18.1 KiB)
image.png (4.3 KiB)
image.png (18.9 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

CeasarChenMSFT-3458 avatar image
1 Vote"
CeasarChenMSFT-3458 answered KimYongMin-5297 commented

Hi, @KimYongMin-5297
After my search, Microsoft has not updated mscomctl.ocx (64-bit) for Excel 2016 MSO version. It is recommended that you submit feedback at feedback.Thanks for your understanding.


If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.




· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thanks @CeasarChenMSFT-3458 for your help.

0 Votes 0 ·