MSãGithubã§ã¯ç¢ºãã«äœ¿ããªããªã£ãŠãã
ActiveX ã³ã³ãããŒã«ãš COM ã¢ãã€ã³ã®äºææ§
æ¢åã® 32 ããã ActiveX ã³ã³ãããŒã«ã¯ Office ã® 64 ããã ããŒãžã§ã³ãšäºææ§ããããŸãããActiveX ã³ã³ãããŒã«ãš COM ãªããžã§ã¯ãã«ã€ããŠã¯ã次ã®ããã«ããŠãã ããã
- ãœãŒã¹ ã³ãŒããããã°ã64 ããã ããŒãžã§ã³ãèªåã§çæããŸãã
- ãœãŒã¹ ã³ãŒãããªããã°ã販売å ã«æŽæ°ãããããŒãžã§ã³ãè«æ±ããŠãã ããã
Office ã®ãã€ãã£ãã® 64 ããã ããã»ã¹ã§ã¯ 32 ãããã®ãã€ããªãèªã¿èŸŒãããšãã§ããŸãããããã«ã¯ã MSComCtl ã®äžè¬çãªã³ã³ãããŒã« (TabStripãToolbarãStatusBarãProgressBarãTreeViewãListViewsãImageListãSliderãImageComboBox) ãšã MSComCt2 ã®ã³ã³ãããŒã« (AnimationãUpDownãMonthViewãDateTimePickerãFlatScrollBar) ãå«ãŸããŸãããããã®ã³ã³ãããŒã«ã¯ãOffice 2010 ããåã® 32 ããã ããŒãžã§ã³ã® Office ã§ã€ã³ã¹ããŒã«ãããŸããã64 ããã ããŒãžã§ã³ã® Office ã«ã³ãŒããç§»è¡ãããšãã«ãããã®ã³ã³ãããŒã«ãäœ¿ãæ¢åã® VBA ãœãªã¥ãŒã·ã§ã³ã®ä»£æ¿çãèŠã€ããå¿ èŠããããŸãã
確ãã«MSComCt2ã¯å šããã®ååšãããã®ä»ã®ã³ã³ãããŒã«ã§çŸããªãããããMSComCtlã®ãã®ã¯çŸããã
æé
ãšããããExcelã¯ããããã«ã¹ã¿ã ããããŠãããããããªãã®ã§Wordã䜿ããŸãã
UserFormã®æ¿å ¥
ãã©ãŒã ãæ¿å
¥ããŸã
ãããªæãã§Userform1ãã§ããŸãã
ããŒã«ããã¯ã¹ã«é 眮
ãã®ãŸãŸã§ã¯æ¿å
¥ã§ããªãã®ã§ToolBoxã«é
眮ããŸãã
ããã§ãªããã§ããªãã¯ãã®VB6.0ç³»ãéžã¹ãŸãã
ImageListã¯äœ¿ããŸãããããšããããèµ·åããŸãã
- Microsoft Listview Control, Version 6.0
- Microsoft Imagelistcontrol , version 6.0
- Microsoft ProgressBar Control, version 6.0
- Microsoft Treeview Control, version 6.0
- Microsoft StatusBar Control, version 6.0
ãªããèŠããªãMSCOMCTL.OCX
C:\Windows\System32\MSCOMCTL.OCX
äžã®ç»åã«ã¯ç¢ºãã«MSCOMCTL.OCXãšæžããŠããããã§ãã
ã€ããã£ãšã€ãã§ããããã£ãŠã¿ããTrueã§ãããCreateObject("Scripting.FilesystemObject").Fileexists("C:\Windows\System32\MSCOMCTL.OCX")
ãªãSYSWowã¯Falseã§ããã
ãã®ãããåçŽãªåç
§èšå®ã§ã¯ã§ããŸããã
ã³ã³ãããŒã«ã«ååãä»ããŠã«ã¹ã¿ãã€ãº
æåã¯éžæããã³ã³ãããŒã«ã«ã¯äžæãšããæžããŠããªããããããã«å³ã¯ãªãã¯ããŠã«ã¹ã¿ãã€ãºããŸããå€å以åã¯ããããçŸè±¡ã¯èµ·ããªãã£ããšæããŸãããŸããäžåºŠç»é²ãããšããã®ãã¡ã€ã«éå®ãªã®ãäžæã§ãããååãåºå®ãããäžåºŠåé€ããŠãŸã远å ããŠããäžæãã§ã¯ãªãèªåã§ã«ã¹ã¿ã ããååãä»ããŸãã
UserFormãžåã³ã³ãããŒã«ãé 眮
倧ããã¯äžã®ã³ãŒãã«æžããŠãããŸãã
ããšã®UserForm1ãããçšåºŠå€§ãããã°ããã§ãã
Listviewã¯å°ãããšè¡šç€ºãããªãã®ã§ã倧ããã«ããŠãã ããã
ProgressBar
Status Bar
ListView
TreeView
ImageListãé
眮ããŸããã
èŠãã¥ãããšæããŸãããiãšæžããŠãããšãããStatusBarã§ãã
Userform1ãå³ã¯ãªãã¯ããŠã³ãŒãã衚瀺ãããŸãã
äžèšã®ã³ãŒããã³ããŒããŠè²Œãä»ããŸãã
ãã©ãŒã ã®ã¢ãžã¥ãŒã«ã«åŒµãä»ããããšã«æ³šæããŠãã ããã
Option Explicit
'ãã£ã³ã»ã«åŠççšãã©ã°
Public IsCancel As Boolean
'åæå
Private Sub UserForm_Initialize()
Dim i As Long, TargetNode As Node
'ãã£ã³ã»ã«ãã©ã°ã«Falseãèšå®
IsCancel = False
With UserForm1
.Height = 384.75
.Width = 552
.Top = 0
.Left = 0
.StartUpPosition = 1
.KeepScrollBarsVisible = fmScrollBarsBoth
.ScrollBars = fmScrollBarsNone
.ScrollLeft = 0
.ScrollTop = 0
.ScrollWidth = 0
.ScrollHeight = 0
.Zoom = 100
.MousePointer = fmMousePointerDefault
End With
With ImageList1
With .ListImages
.Clear
' .Add
End With
' .ListImages.Add
' .ListImages.Add 2, "Sheet", SheetImage
End With
With TreeView1
.Height = 198
.Left = 0
.Top = 0
.Width = 408
.FullRowSelect = False
.HideSelection = True
.LabelEdit = tvwAutomatic
.SingleSel = False
.Sorted = False
.Style = tvwTreelinesPlusMinusPictureText
.Checkboxes = False
.HotTracking = False
.LineStyle = tvwTreeLines
.Nodes.Clear
.Indentation = 14
.LabelEdit = tvwManual
.BorderStyle = ccNone
.HideSelection = False
.LineStyle = tvwRootLines
'.ImageList = ImageList1
'http://officetanaka.net/excel/vba/treeview/05.htm
.Nodes.Add , , "_Name", "æ°å"
.Nodes.Add , , "_Address", "äœæ"
.Nodes.Add "_Name", tvwChild, "tanaka", "ç°äž"
.Nodes.Add "tanaka", tvwChild, , "è¶£å³"
.Nodes.Add "tanaka", tvwChild, , "ç¹æ"
End With
'http://officetanaka.net/excel/vba/listview/05.htm
With ListView1
''ããããã£
.Height = 120
.Left = 0
.Top = 210
.Width = 510
.AllowColumnReorder = False
.Arrange = lvwNone
.View = lvwReport ''衚瀺
.LabelEdit = lvwManual ''ã©ãã«ã®ç·šé
.HideSelection = False ''éžæã®èªåè§£é€
.AllowColumnReorder = True ''åå¹
ã®å€æŽãèš±å¯
.FullRowSelect = True ''è¡å
šäœãéžæ
.Gridlines = True ''ã°ãªããç·
''åèŠåºã
.ColumnHeaders.Add , "_Name", "åå"
.ColumnHeaders.Add , "_Age", "幎霢", , lvwColumnCenter
.ColumnHeaders.Add , "_Address", "äœæ", , lvwColumnRight
End With
With ListView1
''1è¡ç®
With .ListItems.Add
.Text = "ç°äž"
.SubItems(1) = 38
.SubItems(2) = "暪æµ"
End With
''2è¡ç®
With .ListItems.Add
.Text = "éŽæš"
.SubItems(1) = 28
.SubItems(2) = "æ±äº¬"
End With
''3è¡ç®
With .ListItems.Add
.Text = "å±±ç°"
.SubItems(1) = 41
.SubItems(2) = "åŒç"
End With
End With
' StatusBar1.ShowTips = True
With StatusBar1
.Left = 456
.Top = 90
.Width = 54
.Height = 30
.Enabled = True
.Font = "MS UI Gothic"
.MousePointer = ccDefault
.Style = sbrSimple
StatusBar1.SimpleText = "test"
End With
'[VBAã§ããã°ã¬ã¹ããŒãã©ãŒã ã衚瀺ãã](https://kowaza.withinit.com/vba/vba_ProgressBarForm.html) ãã ãApplication.cursorã¯Wordã§ã¯ç¡å¹
With ProgressBar1
.Height = 18
.Left = 30
.Top = 336
.Width = 192
.Orientation = ccOrientationHorizontal
.Scrolling = ccScrollingStandard
.Value = 88
End With
End Sub
Private Sub UserForm_Terminate()
Unload UserForm1
End Sub
ImageListã ããåããªã
ããã¯ããããã£ããŒãžããç»é²ããããšãã§ããŸããã
TreeViewã®ã³ãŒãã¯OfficeTanaka倧å
çã®ãã®ã§ãã
ãã®Treeviewã®äœ¿ãæ¹ã¯ãšãŠãå匷ã«ãªã£ããã®ã§ãã
ããããªããããã®èšäºã®å段ã®ãImageListã®ç»é²ãã§ããŸããã
ãã®ãããåŸåã®ã³ãŒãã®ãImageã¯å
¥ã£ãŠããªãç¹ããã®èšäºã®ã³ãŒãã®éãã§ãã
Imageç»é²ã®æé ã®ããããã£ããŒãžãéãããšããŠã
Microsoft Visual Basic for Applications
次ã®ã¯ã©ã¹ã¯ç»é²ãããŠããŸãããæ¬¡ã®CLSIDãªããžã§ã¯ããåç §ããŠãã ããã
{7EBDAAE1-8120-11CF-899F-00AA00688B10}
ãã®ããã«ãšã©ãŒãåºãŸãã
VBAãClearãŸã§ã¯ã§ããŸãããç¡çã§ããã
ãŸã
æçš¿æ¥: 2018幎2æ24æ¥(2019幎6æ16æ¥) æçš¿è
: rohhie
VBAã§TreeViewãImageListã®ããããã£ããŒãžãéããªã
ããããOffice2019ã®64Bitçã§ImagelistãåããªããŠè©±ã¯èª°ãèããŠããªãã¯ãã§ã¯ã
ããã¯ãããããšããããããªãã§ããã®ãããªãListImageã¯ã ããªã®ãããããããŸããã
ããŒãžã§ã³æ
å ±ãã¯ãªãã¯ãããšããããåºãŠããŸã
ãããã¯ãªãã¯ãããšãããŒãžã§ã³æ
å ±ãåºãŸãã
ã芧ãã ãããWord 2019ã«ãããŠ20幎åã®ControlãåããŠããã®ã§ããããããã°ãªã®ããæ¥æ¬èªçã ããªã®ãããããŸãããåœæ¹ã®ããŒãžã§ã³ã¯Insiderã§ã¯ãããŸããã
ãã埩掻ããã®ã§ããã°ãImageListããªããŠããããããã§ãã
ProgressBarããªããŠStatusBarã工倫ãããã
ListViewããªããŠæ¹è¡ãTabã§MsgBoxã§èŠåŽããã
TreeviewããªããŠæ¬¡ã
ãšå±éããæ¥œãã¿ããªããªã£ããã
æ¬åœã«Microsoft Ofiiceã¯ã€ãŸããªããœããã«ãªã£ããšããããŠããã®ã§ãããããããŠãã®äžçãçµãããããããªããšãã2020幎4æãšããç¶æ³ã§ãŸãäŒããã®ã¯ã¡ãã£ãšããããçµéšã§ãã
ãããªãMSComctlLib
ããšImageListã¯InitializeãåºãŠããŸãããããããã®æ©èœã䜿ããªãçç±ã§ãããã®ããåæåãèŠæ±ããã®ã§ã
ãªãStatusBarã«iãå
¥ã£ãŠããã®ã¯åã®ã³ãŒãããããããã£ã§å
¥åããããã§ããèŠãã¥ããã®ã§æ®ããŸãããStatusBarã«è²ã§ãããããšæã£ãã®ã§ãããè²ã¯ä»ããããªãã¿ããã§ãããã®äžçã®çµããã«ãŸããã ããªãããªãã¢ãèŠã€ããŠããŸã£ãããããæ¬åœã«TreeViewã®ã³ãŒãã£ãŠãããã«ããã§ãããå®å®éã¿ã€ããã¥ãŒã©ãŒçè«ã®æ¹ããŸã ããããããã§ããã
ãããªãMSComctlLibãMSComctlLibããªããšFormããã¶ã€ã³ããæ°ã«ãªããªããã§ãåé€ãããéåœã®ã¯ãããŸããäŒãããšã¯æã£ãŠããªãã£ããæ¥œããçµéšãããããšãã
è£è¶³
MSComCt2ã«ã€ããŠ
ãªããMSComCt2ã¯ããçŸãããšããã°ãMicrosoft Windows Common Controls-2 6.0(SP6)ãšããååã«ãªãã
ãã®ãœãŒã¹ã¯ã¢ãã¡ãŒã·ã§ã³(Animation)ã³ã³ãããŒã«ã䜿ã£ãŠ AVI ã¢ãã¡ãŒã·ã§ã³ãã¡ã€ã«ã衚瀺ãã - ã¬ã¹ãã¥ãŒè±ã¡ãã
Animationãšããã®ã¯AVIãã¡ã€ã«ãåãããã®ã ã£ãããã§ããã¡ãªã¿ã«ãªã³ã¯å
ã®ã¢ãã¡ãŒã·ã§ã³ãåãããããçžåœæ°ã®ãã£ããããã¥ã³æ»ããã§ãããã
ãã®ã³ã³ãããŒã«çŸ€ã®ãã£ãšãæåãªãã®ãDateTimePickerã§ããã«ã¬ã³ããŒåœ¢åŒã§è¡šç€ºãããæ¥ä»ãã¯ãªãã¯ãããšå
¥åãããããšãããã®ã§ãããªãããããã®ãåãã®ãçè§£ã§ããªãã§ããã©ãã
ãã®ããã«åŸ©æŽ»ããåå
[MS12-027] MSCOMCTL.OCX ã®è匱æ§ã«ããããªã¢ãŒãã§ã³ãŒããå®è¡ããã (2012 幎 4 æ 10 æ¥)
https://support.microsoft.com/ja-jp/help/2664258/ms12-027-vulnerability-in-mscomctl-ocx-could-allow-remote-code-executi
WindowsUpdateã«ããmscomctl.ocxã®åœ±é¿ãšæãããçç¶ããããŸãããïŒ 2012/4/12 23:24:19
https://detail.chiebukuro.yahoo.co.jp/qa/question_detail/q1485495039
Win vista ãš Win7
Excel2007 VBA4ææäŸã¢ããããŒãã§ããMS12-027ããšããŠMSCOMCTL.OCXããããã®å¯Ÿè±¡ãšãªããŸããããã¢ããããŒãåŸãListViewãå«ããã©ãŒã ããç¡å¹ãªãªããžã§ã¯ãã©ã€ãã©ãªã§ãããŸãã¯å®çŸ©ãããŠããªããªããžã§ã¯ããžã®åç §ãå«ãã§ããŸãããšãããšã©ãŒãçºçããŠäœ¿çšã§ããªããªããŸããã
Win7ã¯ãregsvr32 C:\Windows\System32\MSCOMCTL.OCXãå®è¡ããããšã§åäœããããã«ãªããŸããããVistaã¯è·å Žã®PCã§ã管çè æš©éã§ã®ãã°ã€ã³ãå¶éãããŠãããããåäœããŠãããŸããã
èªåã®ç°å¢ã§ã¯ãããªæããªã®ã§ãããä»ã®çããã®ç°å¢ã§ãåæ§ã§ããããïŒããã¯MS12-027ã®ä¿®æ£ã«äŒŽãå¯äœçšãšãªã£ãŠãããŸãããã®ä¿®æ£ã«äŒŽããMSCOMCTL.OCXãè匱æ§ã®ããããŒãžã§ã³ããè匱æ§ã®ä¿®æ£ãããããŒãžã§ã³ã«å ¥ãæ¿ããããå ã®ããŒãžã§ã³ã¯KillBitãèšå®ãããŠäœ¿çšäžèœã«ãªããŸãããããããªãããç¹ã«Officeã§ã¯ActiveXã³ã³ãããŒã«(å³å¯ã«ã¯ã¿ã€ãã©ã€ãã©ãª)ãEXDãã¡ã€ã«ã®åœ¢åŒã«å€æããŠãã£ãã·ã¥ããããããã®å€ãããŒãžã§ã³ãåŒãç¶ãåç §ããã圢ã«ãªã£ãŠããŸã£ãŠããŸãã
解決æ³ãšããŠã¯ããŠãŒã¶ãŒãã£ã¬ã¯ããªå ã®
%APPDATA%\Microsoft\Formsãã©ã«ãå ãåã³ãŠãŒã¶ãŒãã³ãã©ãªãã£ã¬ã¯ããªå ã®VBEãã©ã«ãå ã«ãããæ¡åŒµåEXDã®ãã¡ã€ã«ãæåã§åé€ããããšãšãªããŸããã³ãã³ãããã³ãããããstart explorer %APPDATA%ããšããŠMicrosoftâFormsãåã³ãstart explorer %TEMP%ããšããŠVBEãã£ã¬ã¯ããªãéã圢ãšãªããŸãã
[線泚]start explorer %APPDATA%\Microsoft\FormsãšãããšWindows10ã§ãäžçºã§éããŸãã
ãã®èšè¿°ããã³ãã ãšæããŸããMicrosoftã¯ãã®MscomCtl.ocxãåé€ããã®ã§ã¯ãªããäžå¯èŠåããŠã¢ã¯ã»ã¹ãã§ããªãããã«å°å°ããã®ã§ããããããªãããã®å°å°ãå°ãå€ããŠããŸãã
å°å°ã¯2017幎7æ27æ¥ã«è§£é€ãããŠããïŒ2020/09/08远èšïŒ
x64ç°å¢ã§ListViewã¯äœ¿ããªãã¯ãããExcel2019 x64ã§ListViewã䜿ããä»¶ã«é¢ã㊠social.msdn.microsoft.com 2019幎7æ23æ¥ 11:37
ããã¯ã¿ã€ãã«ããã¯ã£ãŠããããã§ã¯ãªããã ããã䜿ããªããšæã£ãŠããã®ã§ïŒå
¬åŒãããæžããŠããããå®éãããããœãŒã¹ãããïŒãããšãGoogleã®æ€çŽ¢ã¯ãé
ããŠãæ€çŽ¢çµæã衚瀺ãããããšãããã®ã§è¿œèšãããšããåºãŠããŸããæ¢ãæ¹ãæªãã®ãããããªããã©ã
ããããWindows10 x64 ã®Excel2019(Professional Plus 2019)ã§ããš
MSCOMCTL.OCXãååšããŠãããåç §ãããšListViewã衚瀺ã»è¿œå ã»æäœããããšãã§ããŸãã
ã³ã³ããŒã«ã®è¿œå ã®äžèЧã«ãListViewãéžæããšããŠååšããå®éã«ListViewããã©ãŒã ã«è¿œå ããããšãã§ããŸããã
ãã ãããªããããŒã«ããã¯ã¹ã«è¡šç€ºãããåç§°ã¯ãListViewãã§ã¯ãªããäžæããšåºãŸãã
Excel2019ïŒã§ã¯ãx64ã®ListViewããµããŒããããã®ã§ããããïŒ
64bitã§ã®MSCOMCTL.OCXã¯office365çã§ã¯2017幎7æ27æ¥ã®æŽæ°ã§ãµããŒããããããã«ãªã£ãŠãŸãã
ãã¡ã€ã«èªäœã¯C:\Program Files\Microsoft Office\root\vfs\Systemã«ãããŸãã
ããã±ãŒãžçã ãšæŽæ°ã¯é ããŸãããããã2019ã§ãµããŒããããŠããã§ãããã
Office suite: Non-security updates
- Add 64-bit support for mscomctl.ocx, allowing users working in 64-bit versions of Office to create, edit, and open macro files containing the Common Controls.
- Improve accessibility of controls used in mscomctl.ocx.
- mscomctl.ocxã®64ããããµããŒãã远å ãããšã64ãããããŒãžã§ã³ã®Officeã§äœæ¥ããŠãããŠãŒã¶ãŒããã³ã¢ã³ã³ã³ãããŒã«ãå«ããã¯ããã¡ã€ã«ãäœæãç·šéãããã³éãããšãã§ããŸãã
- mscomctl.ocxã§äœ¿çšãããã³ã³ãããŒã«ã®ã¢ã¯ã»ã·ããªãã£ãæ¹åããŸãã
äžæãšåºãã®ãã¢ã¯ã»ã·ããªãã£ã§æ¹åãšããã®ãæ£æ°ãªã®ã ããããGoogle翻蚳ãééã£ãŠããã®ãïŒ
ãããGoogleã§"monthly-channel" "mscomctl.ocx"ã§æ€çŽ¢ãããšãã®ææ¬¡ãã£ãã«ä»¥éã§èšåãããããšã¯ãªããããããŸãITMediaçã®ã¡ãžã£ãŒãªãã¥ãŒã¹ã§ãæ±ãããŠããªããããããšããããããªãã¡ããã¡ããªåºçŸæ¹æ³ã§ã¯äžå®ã§ä»æ¹ãªãããããåŸåã®ãã°ãåŒããã£ããŸãŸã®ããã ãæ¬¡ãããããèšäºã«ãªãã
Excel2016ã§ListViewãå©çšã§ããªãâ answers.microsoft.com 2019/03/29
ã¯ãŒã¯ã·ãŒãã«ListViewãé 眮ããŠããªã¹ãã«å€ã衚瀺ããã
èšå®ãVBAã§è¡ãããã®ã§ãããExcel2010(32Bit)ã§äœæãã
ãã®ã Excel2016(32Bit)ã ãšäžèšã®çŸè±¡ïŒå®è¡æãšã©ãŒ:380:Invalid property valueçïŒãçºçããŠäœ¿ããªã
ãªããŸãã以äžã®èšäºã«åæ§ã®åé¡ã§è§£æ±ºããããšããã³ã¡ã³ãããããŸããã®ã§ç¢ºèªããŠã¿ããšã©ãã§ããããã
â Excel VBA listview control gives âInvalid property valueâ error when setting width
https://stackoverflow.com/questions/34135263/excel-vba-listview-control-gives-invalid-property-value-error-when-setting-wid
- I know this thread is old, but I ran into this same issue recently when upgrading from Office 2010 to Office 2016 and I hope this answer will help anyone else who gets stuck with this frustrating problem.
- A workaround that I have found which works fairly well is to auto set the width of each column.
- ç§ã¯ãã®ã¹ã¬ãããå€ãããšãç¥ã£ãŠããŸãããOffice 2010ããOffice 2016ã«ã¢ããã°ã¬ãŒããããšãã«æè¿åãåé¡ã«ééããŸããããã®åçããã®èç«ãããåé¡ã§å°ã£ãŠããä»ã®äººã«åœ¹ç«ã€ããšãé¡ã£ãŠããŸãã
- ç§ãããªãããŸãããããšãããã£ãåé¿çã¯ãååã®å¹ ãèªåèšå®ããããšã§ãã
解決ãããªãå Žåãªã©ãVBA å°çšã®ã«ããŽãªããã éçºè åãã® Msdn ãã©ãŒã©ã ã«ãæçš¿ããŠæ å ±ãéããŠã¿ãŠäžããããè¿ä¿¡ããããšãããããŸãã
ListViewã®äœ¿ãæ¹ã調ã¹ããšãŠãŒã¶ãŒãã©ãŒã ã«ãé 眮ããäºãåºæ¬çãªäœ¿ãæ¹ã®æ§ãªã®ã§ããã®æ¹åã§èããããšã«ããŸãã
æ å ±ããããšãããããŸããâ
解決ããã®ãããŠãªãã®ãããããããã«ããå€ããã°ãåŒããã£ããŸãŸãããã
Office Update ships âwrongâ MSComCTL.ocx (Jan. 2019) GÃŒnter Born
Posted on 2019-02-07 by guenni
Windows Update[German]Blog reader Sam pointed out an issue with Microsoftâs MS Common controls (thanks for that), which is causing trouble. Microsoft ships wrong versions of MS Common Controls (MSComCTL.ocx) via Office update. In January 2019 it probably happened again with an Office 2019 update.
Windows Update [ãã€ãèª]ããã°ãªãŒããŒã®SamããMicrosoftã®MS Commonã³ã³ãããŒã«ã«åé¡ãããããšãææããŸããïŒãã®ãããã§ïŒãåé¡ãçºçããŠããŸãã ãã€ã¯ããœããã¯ãOfficeã®ã¢ããããŒããéããŠãMS Common ControlsïŒMSComCTL.ocxïŒã®ééã£ãããŒãžã§ã³ãåºè·ããŠããŸãã 2019幎1æã«ãOffice 2019ã®æŽæ°ã«ããããããåã³çºçããŸããã
An old case from 2017
(äžç¥ãªãã2019幎ã®ãã°ã¯2017幎ãšå¯Ÿæ¯ããŠèšèŒãããŠãã)
A new case in 2019?
I guess something like that happened again. Blog reader Sam sent me the following text.I have noticed that Microsoft delivers another wrong file version of the MS Common Controls (mscomctl.ocx) with the Office January 2019 updates. It affects the following file:
18.01.2019 22:33 1â410â216 MSCOMCTL.OCX
With Office 2019 C2R this is especially stupid, because there is only a new build. A manual deinstallation of the respective update is not possible.
With the other Office versions I found absolutely no hints at Microsoft which patch will deliver the wrong MS Common Controls file version in Dec 2018 or Jan 2019. MS is totally silent here.
Probably because about 2 years ago the same misery has already happended [GB: See my hints above].Within this Technet thread similar issues with Microsoft Office 365 ProPlus Build 10730.20264 and MSCOMCT.ocx are discussed. Sombody solved it in the following way:
- Unregister the OCX by RegSvr32 /u âC:\Windows\SysWOW64\MSCOMCTL.ocxâ in C:\Windows\SysWOW64.
- Delete the OCX file from C:\Windows\SysWOW64 folder.
- Restart the PC.
- Place an earlier version of the OCX (6.01.9846) into C:\Windows\SysWOW64.
- Register the OCX by RegSvr32 âC:\Windows\SysWOW64\MSCOMCTL.ocxâ.
After a re-registration of the replaced .OCX file the controls worked again. Anyone else affected?
2019å¹Žã®æ°ããäºä»¶ïŒ
ãã®ãããªããšããŸãèµ·ãã£ããšæããŸãã ããã°ãªãŒããŒã®Samããæ¬¡ã®ããã¹ããéãããŠããŸãããç§ã¯ãMicrosoftãOffice Common 2019ïŒ2019幎1æïŒã®ã¢ããããŒãã§å¥ã®èª€ã£ããã¡ã€ã«ããŒãžã§ã³ã®MS Common ControlsïŒmscomctl.ocxïŒãæäŸããŠããããšã«æ°ä»ããŸããã æ¬¡ã®ãã¡ã€ã«ã«åœ±é¿ããŸãã
18.01.2019 22:33 1â410â216 MSCOMCTL.OCX
Office 2019 C2Rã§ã¯ãæ°ãããã«ããããªããããããã¯ç¹ã«æãã§ãã ããããã®ã¢ããããŒããæåã§ã¢ã³ã€ã³ã¹ããŒã«ããããšã¯ã§ããŸããã
ä»ã®OfficeããŒãžã§ã³ã§ã¯ãã©ã®ããããééã£ãMS Common Controlsãã¡ã€ã«ããŒãžã§ã³ã2018幎12æãŸãã¯2019幎1æã«é ä¿¡ããããšãããã³ããMicrosoftã§ãŸã£ããèŠã€ããããŸããã§ãããMSã¯ããã§å®å šã«ãµã€ã¬ã³ãã§ãã
ãããããçŽ2幎åã«åãæ²æšãããã§ã«èµ·ãã£ãŠããããã§ã[GBïŒäžèšã®ç§ã®ãã³ããåç §]ããã®Technetã¹ã¬ããå ã§ãMicrosoft Office 365 ProPlusãã«ã10730.20264ããã³MSCOMCT.ocxã®åæ§ã®åé¡ã«ã€ããŠèª¬æããŸãã Sombodyã¯æ¬¡ã®æ¹æ³ã§è§£æ±ºããŸãããïŒä»¥äžäžã®1.ãã5.ã®æé ïŒ
ãšããŠãããããããªå€ãocxãä¿åããŠããªãã®ã§ã¯ããšãããããããªæ
å ±ãMSã«ã¯ãªãã
Report of a buggy MSComCTL.ocx in Januaryâs Office patches. Again. AskWoody
ãã®èšäºã¯ããã§ã話é¡ã«ãªã£ãŠãããããŸãç¥ãããŠããªããšæãããVBAã«ã€ããŠæ€çŽ¢ãããšãã€ãèªããã©ã³ã¹èªãããªããããããããããã€ãã®æè¡ã¯äžçäžã§ãããééã£ãŠãã·ã¥ãããã€ã ã«ãªã£ãŠã¯ãããªãããªããã¢ãã€ã³ã§æ·±å»ãªåé¡ããããããäžè¬çã«ã¯åé¡ããªããšãããŠããŠã次ã®ãšãããèŠãéãããã€ã¯ããœããã¯ããã£ãšä¿®åŸ©ããã®ã§ã¯ãªãããšæãããã
2020/05/22
é©çšå¯Ÿè±¡:Access for Office 365, Access 2019, Access 2016, Access 2013, Access 2010, Microsoft Office Access 2007
çŸè±¡
ã»ãã¥ãªãã£æ å ± MS16-004 ã«èšèŒãããŠããã»ãã¥ãªãã£æŽæ°ããã°ã©ã 2881067ã2881029ã3039794ããŸãã¯2920727ãé©çšãããšãç¹å®ã® Windows ã³ã¢ã³ã³ã³ãããŒã«ã䜿çšããå Žåã« Access ããŒã¿ããŒã¹ã«åœ±é¿ããåé¡ãçºçããŸãã å ·äœçã«ã¯ãMSCOMCTL ã«é¢é£ä»ããããŠããã³ã³ãããŒã«ã䜿çšãããšããããã®åé¡ãçºçããŸããã»ãã¥ãªãã£æŽæ°ããã°ã©ã ã§æŽæ°ããã OCX ãã¡ã€ã«ã ãããã®åé¡ã«ã¯ã次ã®ãããªãã®ããããŸãã
- ãã®ãããªã³ã³ãããŒã«ã®1ã€ãå«ããªããžã§ã¯ããéãããšãããšãããã°ã©ã ãã¯ã©ãã·ã¥ããŸãã
- ã€ãã³ããåãæ¶ãããããšã瀺ããšã©ãŒã¡ãã»ãŒãžã衚瀺ãããŸãã ãšã©ãŒã¡ãã»ãŒãžã®äŸã以äžã«ç€ºããŸã (ãã ããå¶éã¯ãããŸãã)ã
Error 459: Object or class does not support the set of events. 2501: <EventName> action cancelled. The expression <EventName> you entered as the event property setting produced the following error: Object of class does not support the set of events.åå
ãã®åé¡ã¯ãã»ãã¥ãªãã£æŽæ°ããã°ã©ã MS16-004 ã«ãã£ãŠãæ¢åã® Access ããŒã¿ããŒã¹ãŸãã¯ãã¶ã€ã³ãã¥ãŒã§ãç¹å®ã® ActiveX ã³ã³ãããŒã«ãæ£ããèªã¿èŸŒãŸããªãããšãããããã«çºçããŸãã
è§£æ±ºæ¹æ³
To fix this problem, reregister the MSCOMCTL.OCX file. If Method 1 does not fix the problem, you may have to use Method 2 to first manually delete a registry key that's associated with MSCOMCTL.OCX.ãã®åé¡ã解決ããã«ã¯ãMSCOMCTL ãåç»é²ããŸããOCX ãã¡ã€ã« æ¹æ³1ã§åé¡ã解決ããªãå Žåã¯ãæåã« MSCOMCTL ã«é¢é£ä»ããããŠããã¬ãžã¹ããªããŒãæåã§åé€ããããã«ãæ¹æ³2ã䜿çšããå¿ èŠããããŸããè匱æ§.
ãã®åé¡ã解決ããã«ã¯ãMSCOMCTL.OCXãã¡ã€ã«ãåç»é²ããŸãã æ¹æ³1ã§åé¡ã解決ããªãå Žåã¯ãæ¹æ³2ã䜿çšããŠãæåã«MSCOMCTL.OCXã«é¢é£ä»ããããŠããã¬ãžã¹ããªããŒãæåã§åé€ããå¿ èŠããããŸãã
ãªã2016幎ã®ãã°ã2020幎ã«è§£æ±ºããã®ããåœç¶2019幎1æã®åé¡ãããã£ãšè§£æ±ºããŠãããšèŠãã¹ãã ãããç²é極ãŸããªããã§ããã®èšäºãã¿ã€ã ã¹ã¿ã³ããèªåã®èšäºããããšãªãã ãã©ããŸã人ã®èšäºãèŠãŠããã£ãšæžããã®ãããã
MSCOMCTL.ocx ã v2.2 â v2.1ãž ããããã 2019/10/25
åäžçŽã®éºç©ãšèšããããããVB6ãããªããªäœ¿ã£ãŠãŸãã
ã§ããå¿ã®åã¯å€ããšæããã ïœ
ãã®ããã°ã®æ€çŽ¢äžäœã¯ãŒãã MSCOMCTL ã ãã®ã
PCè²ã èŠæžã
VB6 ã§MSCOMCTL.OCX ã 2.1â2.2 ã«ããŒãžã§ã³ã¢ãã
4æã«v2.2ãžããŒãžã§ã³ã¢ãããã MSCOMCTL.ocx ã ããäžåºŠ v2.1 ã«æ»ãå¿ èŠãåºãŠããŸãããäœæ ãïŒã瀟é·ã®éçºç°å¢ã v2.1 ã ãããâãåãããŒãžã§ã³ã¢ãããããïŒ
ãã®ããã«ãã€ã¯ããœãããçžåœã ãããŠãŒã¶ãŒãçžåœãªãã®ãªã®ã§ããããããå€ãè¯ãPCã¯ãŒã«ãã§ããã宿¥œæ»ãªããŠèšã£ãŠãªãã§å æ°ã§åž°ã£ãŠããŠãã ããã
å人çãªäºæ³ãšããŠã¯ListImageã¯åŸ©æŽ»ããªããšæããŸã
ãŸããç»åããããã©ã«ãã«ãããŠããããImageListãåæåããŠèªã¿èŸŒããšããã®ããçããããªããããã¯ããŒã«ã«ããŸãã¯ã¹ã¿ã³ãã¢ãã³ãåæã ããã§ããä»ã¯ãããã«ã€ãªãããããã®ããã«ããå¿
èŠããããŸããã
次ã«ãåæå®çŸ©ãããšæªæã®ããã³ãŒãããããã¡ã€ã«ãèªã¿èŸŒãŸããæããããããããã«ç¡çããããŸãã
以äžãããã®æ©èœã¯åŸ©æŽ»ããªããšæãããŸãã
ããããªãã¯ãªã¢ã ãåãã®ããšãããšã以åã®ããŒãžã§ã³ã§äœããããã©ãŒã ãæŽ»çšããããšããå ŽåãImageListããåãã°ã»ãã¥ãªãã£ãäžãã䜿ããããã«ããããã ãšæããŸãããã®ãããåé€ããæ©èœã ããååšããã®ã§ãããã
VB60ã®ã¢ããããŒãã«ã€ããŠ
https://rohhie.net/i-can-not-open-the-property-page-of-treeview-or-imagelist-in-vba/
ãã¡ãã«ç޹ä»ãããŠããæ¹æ³ãè¡ããŸããããããŸãå€åã¯ãªãããã§ãããã ãããªããæåã ãã¯ããŸãã












Comments
Let's comment your feelings that are more than good