title: How to format a closed Excel sheet using VBA
body: <p>I have sheet1.xls which is closed. I am working in sheet2.xls VBA as follows.</p>
  
  <pre><code>With Range("A:XFD")
   &lt;I need Some Code here to format entire sheet1.xls cells into string format&gt; 
  End With
  </code></pre>
  
  <p>Kinldy help.Thanks</p>