Evaluate string to formula with link to online documents.

[Spanja]

Dear Sirs,

I have one problem with evaluation function.

Online file name	Link made by CONCATENATE funcеion (string)
test1 00 123 3123.xlsm	"='http://test.test.com/Manufacturing//[test1 00 123 3123.xlsm]Sheet1'!$B2"
test2 90 43 4.xlsm	"='http://test.test.com/Manufacturing//[test2 90 43 4.xlsm]Sheet1'!$B2"
test 3 103 3123.xlsm	"='http://test.test.com/Manufacturing//[test 3 103 3123.xlsm]Sheet1'!$B2"

<tbody>
</tbody>

I have a list with the name of the files. Next, using the CONCATENATE function, I create formulas to get value from B2 cell of Sheet1 (formuma is as string).
Then with Evaluate function (VBA code):

Function Eval(Ref As String)​

Application.Volatile​

Eval = Evaluate(Ref)​

End Function​

I tried to evaluate from string to formula, but with doesnt work with online file link.
When I save this files on hard drive, it`s work. If I drive this formula manually (with reference to the online document), everything works.

Any idea what is the reason? How to fix?

 

[Macropod]

Cross-posted at: https://www.excelforum.com/excel-ge...to-formula-with-link-to-online-documents.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html