title: Get span value with no class name using VBA
body: <p>Am stuck with this,</p>
  
  <p>VBA code:</p>
  
  <pre><code>Set html = IE.document
  
  Set elements = html.getElementsByClassName("dropdown dropdown-toggle editable-field-title-wrapper")
  
  Dim count As Long
  Dim erow As Long
  count = 0
  For Each element In elements
  If element.className = "dropdown dropdown-toggle editable-field-title- wrapper" Then
  erow = Sheets("Exec").Cells(Rows.count, 1).End(xlUp).Offset(1, 0).Row
  Sheets("Exec").Cells(erow, 1) = html.getElementsByTagName("span") 
  (count).innerText
  
  count = count + 1
  End If
  Next element
  </code></pre>
  
  <p>HTML code:</p>
  
  <pre><code>&lt;span data-link="class{:~getPriorityLabel(fieldValue) ? 'editable-field label-priority-color-' + ~getPriorityLabel(fieldValue) : 'editable-field'}" class="editable-field label-priority-color-high"&gt;
      &lt;span class="dropdown dropdown-toggle editable-field-title-wrapper" data-toggle="dropdown"&gt;
        &lt;script type="jsv#432^"&gt;&lt;/script&gt;&lt;script type="jsv#814_"&gt;&lt;/script&gt;
        &lt;span class="editable-field-title"&gt;Priority:&lt;/span&gt;
        &lt;script type="jsv/814_"&gt;&lt;/script&gt;&lt;script type="jsv/432^"&gt;&lt;/script&gt;
        &lt;span data-link="html{&gt;~isUndefined(fieldValue) ? 'None' : ~capitalize(~getPriorityLabel(fieldValue))}"&gt;**High**&lt;/span&gt;
        &lt;span data-link="visible{:state != 'saving'}" style="display: block;"&gt;
          &lt;span class="caret"&gt;&lt;/span&gt;
        &lt;/span&gt;
        &lt;span data-link="visible{:state == 'saving'}" style="display: none;"&gt;
          &lt;script type="jsv#815_"&gt;&lt;/script&gt;&lt;i class="icon-spinner"&gt;&lt;/i&gt;&lt;script type="jsv/815_"&gt;&lt;/script&gt;
        &lt;/span&gt;
      &lt;/span&gt;
      &lt;ul class="dropdown-menu priority-dropdown pull-right"&gt;&lt;li data-link="visible{:fieldValue}" style="display: list-item;"&gt;
          &lt;a class="editable-field-commit" data-value="-1" href="#" tabindex="0"&gt;None&lt;/a&gt;
        &lt;/li&gt;&lt;li&gt;
          &lt;a class="editable-field-commit" data-value="0.07438533240156266" href="#" tabindex="0"&gt;Low&lt;/a&gt;
        &lt;/li&gt;&lt;li&gt;
          &lt;a class="editable-field-commit" data-value="0.49243981401033865" href="#" tabindex="0"&gt;Medium&lt;/a&gt;
        &lt;/li&gt;&lt;li&gt;
          &lt;a class="editable-field-commit" data-value="0.9642772538736262" href="#" tabindex="0"&gt;High&lt;/a&gt;
        &lt;/li&gt;&lt;/ul&gt;
      &lt;div class="alert alert-error editable-field-message-open-left editable-field-error-message" data-link="html{&gt;errorMessage} visible{:errorMessage}" style="display: none;"&gt;&lt;/div&gt;
      &lt;div class="alert alert-info editable-field-conflict-message" data-link="html{&gt;conflictMessage} visible{:conflictMessage}" style="display: none;"&gt;&lt;/div&gt;
    &lt;/span&gt;
  </code></pre>
  
  <p>Please find the <strong>High</strong> in my HTML code and I want that letter(High) using my Excel VBA code, please help me out.!!</p>
  
  <p>Please find the <strong>High</strong> in my HTML code and I want that letter(High) using my Excel VBA code, please help me out.!!</p>