title: How can I create a new excel file/Workbook in VBA without opening it automatically?
body: <p>I created a subroutine to create a new Excel workbook based on an input string (the new file name). This is below:</p>
  
  <pre><code>Private Sub AddSaveAsNewWorkbook(FILE As String)
  
      Dim path As String
      path = FILE &amp; ".xlsx"
      Set Wk = Workbooks.Add
      With Wk
          .SaveAs Filename:=path
      End With
  End Sub
  </code></pre>
  
  <p>However, I am using this subroutine to generate over 40,000 new files.  My computer will crash if the program opens each of these files every time. Is there any way to do this and not open the Excel file automatically?</p>
  
  <p>Thank you.</p>