VBA Looping through a Collection
<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>