title: Trying to access other files in same folder but getting files outside folder
body: <p>I'm trying to access all the other files in the same folder as the program but it wants to go to files in the entire directory. I get that's basically what I'm telling it to do but I'm still new to vba and don't know the syntax to accomplish what I want. Is there a way that I can get the current folder location from the program and have it go through all the files only in that folder?</p>
  
  <p>Also I'd need a solution that doesn't use the Scripting.Object stuff since I'm running into issues with needing to downloading stuff for that and I feel uncomfortable requiring the people that will use this tool download things too especially since they'll be on secure .mil computers (as opposed to .com computers)</p>
  
  <pre><code>directory = ActiveWorkbook.Path 'Also tried CurDir()
  fileName = Dir(directory &amp; "*.xl??")
  Do While fileName &lt;&gt; ""
     ...
     fileName = Dir()
  Loop
  </code></pre>