title: Excel Vba not opening correct workbooks?
body: <p>My excel code was able to iterate through every workbook in a specified folder, although it does so in an eternal loop. (Which i stop using the keyboard  interrupt)</p>
  
  <p>Vba based off this: <a href="http://www.ozgrid.com/VBA/2007-filesearch-alternative.htm" rel="nofollow">http://www.ozgrid.com/VBA/2007-filesearch-alternative.htm</a></p>
  
  <p>Now, after switching PCs, the code has gone haywire. The vba is still the same but instead of opening workbooks in the specified folder, its opening workbooks in the folder one folder before it. </p>
  
  <p>E.g Vba is in S:\Excel\Test
  It will open books in  S:\Excel 
  Instead of a specified location in C. Drive S is a networked drive</p>
  
  <p>Not only that, while it used to iterate through EVERY file, it now just keeps resetting and opening the first file again and again</p>
  
  <p>Using Excel 2007</p>