This project has moved and is read-only. For the latest updates, please go here.

External File calculation.

Oct 15, 2015 at 9:00 PM
How can get the value of external cell calculation in excel sheet? I use .Calculate method but still It does not return any value.
=SUM('G:\RND\ReadWriteExcelFile\ReadWriteExcelFile\ExlFile[Test1.xlsx]Sheet1'!$A$4:$B$4)

We are using above formul.

Is there any help for this?