Dear Sirs,
I have one problem with evaluation function.
<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):
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?
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?