Excel functions don't work with macro
<p>So I got this macro to load stuff from another worksheet:</p>

<pre><code>Private Sub Workbook_Open()
Workbooks.Open Filename:= _
    "http://DOMAIN/csdav/nodes/5865160/Projektoffertliste.xls"
 ThisWorkbook.RefreshAll
 ActiveWorkbook.Close
End Sub
</code></pre>

<p>and if I try using simple fuctions like =VALUE or =IF it just won't work and it says #VALUE as error code.  </p>

<pre><code>=DATEVALUE('http://DOMAIN/csdav/nodes/5865160/[Projektoffertliste.xls]Projektoffertliste'!B2)
</code></pre>

<p>Thats one usage example, i tried this too with =VALE because I first thought it was a DATEVALUE problem. the http://.... data getting does work but i can't use it with functions.</p>