title: How to create a new Excel spreadsheet from within VB6
body: <p>I am attempting to create an Excel spreadsheet from within a VB6 application thus...</p>
  
  <pre><code>Set xl = New Excel.application
  Set xlwbook = xl.Workbooks.Open(file_name)
  Set xlsheet = xlwbook.Sheets.Item(1)
  </code></pre>
  
  <p>followed by</p>
  
  <pre><code>xlsheet.Cells(1, 1) = "Blah blah blah"
  </code></pre>
  
  <p>and so on.</p>
  
  <p>I specifically want to create a new file every time this operation is performed. At the moment it returns a file not found error.</p>
  
  <p>I'd like to know if this is the right approach, and if so, how I can request that a new file be created by the .Open method (or whatever method I should be using).</p>