I can use the following formula to get a cell value from another excel workbook
Now I try to use the following equation to get the same value
where A1 is the cell that contains text tradingbook.
Unfortuanately this does not work. I have also tried double quotations and so on, all does not work.