CELL("filename") doesn't work on shortcut workbook link?
Hi,
I got a shortcut link of master workbook and I"m trying to find the location
of shortcut linked file.
E.G.
1) C:/master file.xls
2) C:/MyFolder/shortcut to master file.xls
Now when I add this formula to shortcut file =Cell("filename") it shows
C:/master file.xls but I'm interested in C:/MyFolder/shortcut to master
file.xls .
Is it possible?
Thanks
Kevin
|