Advertisement
Guest User

Untitled

a guest
Oct 16th, 2018
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Private Sub CommandButton1_Click()
  2. TextBox1.Text = "Rizio"
  3. Selection.Value = "66"
  4.  
  5. Dim r, c
  6. c = ActiveCell.Column
  7. r = ActiveCell.Row
  8.  
  9. MsgBox r & "x" & c
  10. r = r + 1
  11. Cells(r, c).Value = "67"
  12.  
  13.  
  14.  Dim xml As String
  15.  
  16.     xml = "<root><person><name>Me </name> </person> <person> <name>No Name </name></person></root> "
  17.     Dim oXml As MSXML2.DOMDocument60
  18.     Set oXml = New MSXML2.DOMDocument60
  19.     oXml.LoadXML xml
  20.     Dim oSeqNodes, oSeqNode As IXMLDOMNode
  21.  
  22.     Set oSeqNodes = oXml.SelectNodes("//root/person")
  23.     If oSeqNodes.Length = 0 Then
  24.        'show some message
  25.    Else
  26.         For Each oSeqNode In oSeqNodes
  27.              Debug.Print oSeqNode.SelectSingleNode("name").Text
  28.         Next
  29.     End If
  30.    
  31. 'Dim strXML As String
  32. '
  33. 'strXML = "<root><person><name>Me </name> </person> <person> <name>No Name </name></person></root> "
  34. '
  35. 'Dim objXML As MSXML2.DOMDocument60
  36. '
  37. '    Set objXML = New MSXML2.DOMDocument60
  38. '
  39. '    If Not objXML.LoadXML(strXML) Then  'strXML is the string with XML'
  40. '        Err.Raise objXML.parseError.ErrorCode, , objXML.parseError.reason
  41. '    End If
  42. '
  43. 'Dim point As IXMLDOMNode
  44. 'Set point = objXML.FirstChild
  45. '
  46. '
  47. 'Debug.Print point.SelectSingleNode("name").Text
  48. 'Debug.Print point.SelectSingleNode("person").Text
  49.  
  50. End Sub
  51.  
  52. Private Sub UserForm_Click()
  53.  
  54. End Sub
  55.  
  56. Private Sub UserForm_Initialize()
  57.  
  58. TextBox1.Text = "Mau"
  59.  
  60. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement