title: Opening 2 files with the same Name but different directories
body: <p>I have written a macro which opens 2 comma delimited files (Generic Tables used by Prophet 8.1 ending with a .fac extension), does a comparison and creates another workbook which highlights all the differences.</p>
  
  <p>The macro seems to fail when the files have the same name but has different directories.</p>
  
  <p>What would be the easiest way to overcome this problem without having to actually change the file name as seen in the location? It is against company policy to mess with the actual files as seen in the location. Is there a way to assign some temporary name to the file and not save it?</p>