title: Save an Excel cell to a file
body: <p>I need to save the contents of a cell to an xml file named by another cell.</p>
  
  <p>I need to perform this check for every row in the sheet.</p>
  
  <pre><code>Sub FormatRange()
  
      Dim rng As Range
      Dim row As Range
      Dim cell As Range
  
      Set rng = Range("A1:AG686")
  
      For Each row In rng.Rows
  
  
      Next row
  
  End Sub
  </code></pre>
  
  <p>For each row I need to save cell <code>AG</code> to <code>xml</code> file named after cell <code>C</code> in the same row. </p>
  
  <p>I am guessing I can use StreamWriter to write the file. I think the real problem is referencing the cells I need.</p>