Another Text to Formula Question

[Xpialidocious]

Hi guys,

trying to get the following string to be calculated as a formular;

"'W:\....\Timesheets\[Some Ones_Timesheet.xls]We" & TEXT($I$2, "DDMMYY")& "'!E$15"

Triyed Evaluate() as below but it comes back with ref error

Function Eval(s As String)
Eval = Evaluate(s)
End Function

 

[GlennUK]

First thing, have you tried changing "W to "=W

?