title: Workbook opens but I still get a VBA Subscript out of range error
body: <p>I'm trying to open a workbook through my marco script and I have this error recurring everytime I try to open a workbook. The problem I'm facing is that when I use</p>
  
  <pre><code>Workbooks.Open (strFilePath)
  </code></pre>
  
  <p>where, </p>
  
  <pre><code>strFilePath = "genericfilepath\FileDuplicate.xlsx"
  </code></pre>
  
  <p>The script launches the workbook but I still get a Subscript out of range error. I've also tried to turn of alerts by putting my code in between</p>
  
  <pre><code>Application.DisplayAlerts = False
  .
  .
  Workbooks.Open (strFilePath)
  .
  .
  Application.DisplayAlerts = True
  </code></pre>
  
  <p>I've also tried On Error Resume Next to no avail, the workbook launches but I still get a pop error msg.</p>