title: VBA Looping through a Collection
body: <p>I have a collection of files that I selected in the SelectManyFiles function and I want to run multiple private subs on each Drawing in the collection function. Here's my code:</p>
  
  <pre><code>Sub Main()
  
  Dim Drawing As Object
  Dim Drawings As Collection
  Set Drawings = SelectManyFiles()
  
  For Each Drawing In Drawings
      'Call multiple private subs to run on each drawing
  Next Drawing
  End Sub
  </code></pre>
  
  <p>I think there's something wrong with the loop but not sure exactly! Any help is appreciated.</p>