OCX and DLL References Missing

[tstroh]

Hi everyone.
I created an Excel file with a bunch of VBA programming back in 2013. It was never used but now we are brushing off the dust.
I'm not a strong programmer but can get around with a little direction. I have not looked at VBA since 2013 and I'm getting old and can't remember what I did yesterday.

I'm getting a few code errors that I'm sure are related to references.
I left myself a few notes of the required references but I can't seem to find them under VB editer/tools/references.

My notes say...
1. Macros must be enabled.
2. OCX and DLL References
• Open VB editor, Tools, References
• Required references are:
Visual Basic for Applications
Microsoft Excel 14.0 Object Library
OLE Automation
Microsoft Forms 2.0 Object Library
Microsoft Office 14.0 Object Library
Ref Edit Control
Microsoft Windows Common Controls-2 6.0 (SP6)
Microsoft Scripting Runtime
3. On Windows XP computers Microsoft Windows Common Controls-2 6.0 (SP6)
is sometimes missing. This may show up as missing in VB editor/tools.references or it may be seen execution errors. Editing the event edit for will cause the date picker field to disappear.
• Copy mscomct2.ocx to c:\winnt\system32
• From command line run “regsvr32 c:\winnt\system32\mscomct2.ocx”
4. On Windows 7 computers Microsoft Windows Common Controls-2 6.0 (SP6)
is sometimes missing.
• Copy mscomct2.ocx to c:\windows\syswow64
• From command line run “regsvr32 c:\winnt\system32\mscomct2.ocx”


Any ideas where I can find these or if they are replaced by something else.
I can't tell you what version of Excel we were on when this was created.
We are currently using Office 2010 and I think Office 360.

[ByteMarks]

I've come across various issues with the sp6 common controls, including occasions where they are there and registered but still show as missing.

Solution I found was to dereigister MSCOMCTL and remove it from SysWOW
The copy the attached MSCOMCTL and MSCOMCTL2 to SysWOW
Then register MSCOMCTL

I've attached the files.
Keep the original files in case this doesn't work though.

[tstroh]

Thanks for the information. I'll give it a try.