title: Open Multiple Files from Variable location using VBA
body: <p>I want to open 4 different Excel files saved under same folder using VBA code, but the folder path is not fixed.</p>
  
  <p>Let's say, I have 4 Excel files named A.xlsx, B.xlsx, C.xlsx &amp; D.xlsx under folder named 22-Feb-15 (This folder name will change everyday, but the file names will remain same).</p>
  
  <p>I want VBA code so that I can select the folder manually and once it is selected, all 4 files will open one by one (there are other files too, but I need to open only these 4 files).</p>