MSDATGRD.OCX problem in Windows 10 from Outlook form 2016 with VBA

[gandalf13]

Hi All
I've a project written in VBA in OUTLOOK 2010.
This project uses a UserForm with a DataGrid ActiveX Control 6.0 (SP6).
The OCX is MSDATGRD.OCX.
Now we have to pass everything to Windows 10 with Outlook 2016 and the ocx doesn't work anymore.
I tried different solutions but seems it can not be registerd correctly (we've already registered it and de-register with regsvr32...).

msdatgrd.ocx is too old, I know.... Which is the equivalent gridView that I can use in VBA in a UserfForm under Windows 10 without any problems?

Thanks. Gandalf

[DataMiser]

Do you have the other files that it requires installed also?

; Dependencies for MSDatGrd.ocx

; Default Dependencies ----------------------------------------------

[MSDatGrd.ocx]
Dest=$(WinSysPath)
Register=$(DLLSelfRegister)
Version=6.1.97.82
Uses1=ComCat.dll
Uses2=MSStdFmt.dll
Uses3=
CABFileName=MSDatGrd.cab
CABDefaultURL=http://activex.microsoft.com/controls/vb6
CABINFFile=MSDatGrd.inf

There may be others depending on the locale
see MSDATGRD.DEP for full info

[gandalf13]

Thanks DataMiser, I have this:

; Dependencies for MSDatGrd.ocx

; Default Dependencies ----------------------------------------------

[MSDatGrd.ocx]
Dest=$(WinSysPath)
Register=$(DLLSelfRegister)
Version=6.1.98.16
Uses1=ComCat.dll
Uses2=MSStdFmt.dll
Uses3=
CABFileName=MSDatGrd.cab
CABDefaultURL=http://activex.microsoft.com/controls/vb6
CABINFFile=MSDatGrd.inf

[ComCat.dll]
Dest=$(WinSysPathSysFile)
Register=$(DLLSelfRegister)
Uses1=

Both (ComCat.dll and MSStdFmt.dll )are under my C:\Windows\SysWOW64
Instead I have only the ComCat.dll under C:\Windows\System32

Do you have the other files that it requires installed also?



There may be others depending on the locale
see MSDATGRD.DEP for full info

[DataMiser]

Both (ComCat.dll and MSStdFmt.dll )are under my C:\Windows\SysWOW64
Instead I have only the ComCat.dll under C:\Windows\System32

That is a bit confusing as worded. I assume you are saying that both files are in the one folder and only the one file is in the other, if so then that would appear to be normal.

I should probably also ask where you tried to register the ocx. It should be in the Syswow64 folder.

[gandalf13]

I registered msdatdrg.ocx in SysWow64.
The others 2 dll were already in the folder.
Even though the registration has done correctly I can't see the component in the toolbox panel.
Thanks.

That is a bit confusing as worded. I assume you are saying that both files are in the one folder and only the one file is in the other, if so then that would appear to be normal.

I should probably also ask where you tried to register the ocx. It should be in the Syswow64 folder.

[gandalf13]

The problem now is that I can choose the reference on the "Reference menu", but when I try to insert in a user form the ocx I cannot see it on the menu/ additional controls.
Neither Microsoft DataGrid Control nor Microsoft FlexGrid Control and also the ListView Control...in the case I would change with another control.
Why I can't see these controls on the toolboox "Addictional controls"?

[DataMiser]

No idea, I have never worked in VBA through outlook, I don't use Outlook 2016 nor Windows 10 so aside from making sure the control is properly registered can't be of much help there.