title: Workbooks.Open Method in VBA
body: <p>My vba script in <strong>myMacro.xls</strong> <code>Workbooks.Open</code> Method work well as below,</p>
  
  <pre><code>Workbooks.Open Filename:="D:\ExcelMacroProj\myTest.xls", ReadOnly:=True
  </code></pre>
  
  <p>But when I try to change the <code>Filename</code> value to a new path as below, but all my practices didn't work. Show <strong>Run time error 1004</strong>.</p>
  
  <pre><code>Workbooks.Open Filename:="myTest.xls", ReadOnly:=True
  or
  Workbooks.Open Filename:="./myTest.xls", ReadOnly:=True
  or
  Workbooks.Open Filename:=".\myTest.xls", ReadOnly:=True
  </code></pre>
  
  <p>Actually <strong>myMacro.xls</strong> and <strong>myTest.xls</strong> was placed in the same folder. That's why I want to change to a flexible folder directory.   </p>
  
  <p>how could I fix this issue? Appreciated for your read and reply. </p>