title: I want to open and run a VBA macro without showing the new Excel window open
body: <p>I have built a macro that opens runs a macro in the opened Excel file then closes. Can I make it so when the new window opens it does not show (hidden)?
  If I can how do I add it to the code below? </p>
  
  <pre><code>Sub Open_Fill_Close()
  
  Worksheets("Sheet1").Select
  invoiceNo = Range("A1")
  
  Set myData = Workbooks.Open("HD:Users:UserT:Desktop:QR.xlsm")
  Worksheets("QR Code").Select
  Worksheets("QR Code").Range("Y39").Select
  RowCount = Worksheets("QR Code").Range("Y39").CurrentRegion.Rows.Count
  With Worksheets("QR Code").Range("Y39")
      .Offset(RowCount, 0) = invoiceNo
  
  End With
  
  Application.Run "QR.xlsm!ExportCellsAsPicture"
  
  Workbooks("QR.xlsm").Close False
  
  End Sub
  </code></pre>