CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 7 of 7
  1. #1
    Join Date
    Feb 2017
    Posts
    4

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

    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

  2. #2
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

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

    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
    Always use [code][/code] tags when posting code.

  3. #3
    Join Date
    Feb 2017
    Posts
    4

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

    Thanks DataMiser, I have this:
    Code:
    ; 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



    Quote Originally Posted by DataMiser View Post
    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

  4. #4
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

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

    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.
    Always use [code][/code] tags when posting code.

  5. #5
    Join Date
    Feb 2017
    Posts
    4

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

    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.

    Quote Originally Posted by DataMiser View Post
    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.

  6. #6
    Join Date
    Feb 2017
    Posts
    4

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

    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"?

  7. #7
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,362

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

    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.
    Always use [code][/code] tags when posting code.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured