title: VBA string variables does not put constant string value in string concatenating
body: <p>all. My code like this:</p>
  
  <pre><code>Sub mySub
  
  Public Const strVarA As String = "AA"
  Public Const strVarB As String = "BB"
  Public Const strVarC As String = "CC"
  
  Dim myStrArray() As String
  Dim myString As String
  myStrArray = ["strVarA", "strVarB", "strVarC"]
  
  For i = 0 To 2
      myURL = "http://www.yahoo.com/news/" &amp; myStrArray(i) &amp; ".html" &lt;--- Here, wrong
      '//do something.
  Next i
  
  End Sub
  </code></pre>
  
  <p>My purpose is in the For loop, myStrArray(0) should put its constant value "AA" in the URL,
  like this:</p>
  
  <pre><code>"http://www.yahoo.com/news/AA.html"
  </code></pre>
  
  <p>because the URL use "AA" in its link. But the code always put "strVarA", like this:</p>
  
  <pre><code>"http://www.yahoo.com/news/strVarA.html"
  </code></pre>
  
  <p>Similar as when loop to myStrArray(1), it should put "BB" in URL, myStrArray(2) should put "CC" in URL. I tried many ways, no luck. Does somebody have experience and suggestions about this? Thanks!</p>