tonydev314
New Member
- Joined
- Oct 1, 2022
- Messages
- 26
- Office Version
- 2013
- Platform
- Windows
This is proving somewhat of a saga.
I first learned that for a while you couldn't do this because the type library containing the List View was only x86 compatible.
But then I read this which seemed to suggest you could do it:
SOLVED: MSCOMCTL.OCX Download & Register on 64 Bit Windows – Up & Running Technologies, Tech How To's
Then this post suggested I needed to run this code:
The regsvr32 command worked, but the regtib exe didn't exist, however I was able to find a copy of regtlibv12.exe from here
Running this against msdatasrc.tlb now worked successfully.
I rebooted and went into Excel - the mscomctl.ocx wasn't listed in References - I had to Browse to it, but when I added it as a reference, I got the error message "can't remove control or reference in use". Neverthless the component now showed up with a tick as Microsoft Common Control Library 6.0 (SP6)
However if I go into Form Additional Controls, List View is not there - none of the mscomctl controls are there.
Anyone able to assist?
I first learned that for a while you couldn't do this because the type library containing the List View was only x86 compatible.
But then I read this which seemed to suggest you could do it:
SOLVED: MSCOMCTL.OCX Download & Register on 64 Bit Windows – Up & Running Technologies, Tech How To's
Then this post suggested I needed to run this code:
VBA Code:
cd C:\Windows\SysWOW64
regsvr32 mscomctl.ocx
regtlib msdatsrc.tlb
The regsvr32 command worked, but the regtib exe didn't exist, however I was able to find a copy of regtlibv12.exe from here
Running this against msdatasrc.tlb now worked successfully.
I rebooted and went into Excel - the mscomctl.ocx wasn't listed in References - I had to Browse to it, but when I added it as a reference, I got the error message "can't remove control or reference in use". Neverthless the component now showed up with a tick as Microsoft Common Control Library 6.0 (SP6)
However if I go into Form Additional Controls, List View is not there - none of the mscomctl controls are there.
Anyone able to assist?