たまに使いたい時がある
UsysRibbonsからxmlを取得してcollectionに格納するのもいいかも知れん
object.InvalidateControl メソッドでeditBoxだけ一括処理とか
'参照:Microsoft XML v6.0
Sub listUpIdByControl()
Dim xdoc As New DOMDocument
Dim i As Integer
Dim node As IXMLDOMNode
Dim nodes As IXMLDOMNodeList
Dim xmlattr As IXMLDOMAttribute
xdoc.async = True
xdoc.Load "directory+filename"
Set nodes = xdoc.DocumentElement.SelectNodes("//button") ' "//control_type"
For i = 1 To nodes.Length
Set node = nodes(i - 1)
Set xmlattr = node.Attributes.getNamedItem("id")
Debug.Print node.nodeName, xmlattr.Value
Next
End Sub
Sub listUpId(targetXML As String, targetElement As String)
Dim xdoc As New DOMDocument
Dim i As Integer
Dim node As IXMLDOMNode
Dim nodes As IXMLDOMNodeList
Dim xmlattr As IXMLDOMAttribute
xdoc.LoadXML targetXML
Set nodes = xdoc.DocumentElement.SelectNodes("//" & targetElement)
For i = 1 To nodes.Length
Set node = nodes(i - 1)
Set xmlattr = node.Attributes.getNamedItem("id")
Debug.Print node.nodeName, xmlattr.Value
Next
End Sub
0 件のコメント:
コメントを投稿