CELL("filename") doesn't work on shortcut workbook link?
No. The shortcut in My Folder is simply that, a shortcut to the actual file
which resides on the C drive. Nothing is actually being opened from the
MyFolder.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Kevin" wrote:
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
|