title: Optional Parameter without constants
body: <p>I was wondering how I canspecify a Optional Parameter with a non-constant value?
  Liek this for example:</p>
  
  <pre><code>Private Sub Foo(Optional ByVal Name as String = Application.ExecutablePath)
      MsgBox("name: " &amp; Name)
  End Sub
  </code></pre>
  
  <p>is there a workarround? 
  So I can use a not constant value in the parameter as optional?</p>