title: Difference between CreateObject("Excel.Application") .Workbooks.Open and just Workbooks.Open
body: <p>I am currently using <code>Workbooks.Open</code> to process a large number of files contained in a directory. But opening and closing these files make the files appear in the task bar and I wanted to avoid the constant flickering. </p>
  
  <p>I got a suggestion from that I can use <code>CreateObject</code> to create a new instance since that opens a new Excel instance which is hidden. </p>
  
  <ol>
  <li><p>Is there any other difference between the two ways of opening new workbooks in terms of performance? </p></li>
  <li><p>Also, should I just use one instance of Excel created using <code>CreateObject</code> to open all Workbooks or do I need to create one instance for each workbook I have to process (<em>which seems like a waste of lot of memory and less speed</em>)? </p></li>
  </ol>