Evaluate string to formula with link to online documents.

[Spanja]

Dear Sirs,

I have one problem with evaluation function.

[TABLE="class: grid, width: 663"]
<tbody>[TR]
[TD]Online file name[/TD]
[TD]Link made by CONCATENATE funcеion (string)[/TD]
[/TR]
[TR]
[TD]test1 00 123 3123.xlsm[/TD]
[TD]"='http://test.test.com/Manufacturing//[test1 00 123 3123.xlsm]Sheet1'!$B2"[/TD]
[/TR]
[TR]
[TD]test2 90 43 4.xlsm[/TD]
[TD]"='http://test.test.com/Manufacturing//[test2 90 43 4.xlsm]Sheet1'!$B2"[/TD]
[/TR]
[TR]
[TD]test 3 103 3123.xlsm[/TD]
[TD]"='http://test.test.com/Manufacturing//[test 3 103 3123.xlsm]Sheet1'!$B2"[/TD]
[/TR]
</tbody>[/TABLE]

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