bdfagoodfella
Board Regular
- Joined
- Oct 22, 2004
- Messages
- 64
Many of my workbooks are used by many people in many different departments.
I am tired of trying to correct problems caused by users accidentally creating a copy and then updating the copy instead of my original.
(Disabling the "save as" feature is just not enough.)
I am currently using the formula:
=CELL("filename",A1)
To retrieve the file location and compare it to my intended file location.
Unfortunately, sometimes the formula returns a UNC file path:
\\tpc-fs2\company_common\Production_History.......
And sometimes the formula returns a relative path(which could potentially change):
P:\Production_History……
Does anyone have any ideas on how I could force the formula to always return the UNC file path?
Thanks in advance for any suggestions.
I am tired of trying to correct problems caused by users accidentally creating a copy and then updating the copy instead of my original.
(Disabling the "save as" feature is just not enough.)
I am currently using the formula:
=CELL("filename",A1)
To retrieve the file location and compare it to my intended file location.
Unfortunately, sometimes the formula returns a UNC file path:
\\tpc-fs2\company_common\Production_History.......
And sometimes the formula returns a relative path(which could potentially change):
P:\Production_History……
Does anyone have any ideas on how I could force the formula to always return the UNC file path?
Thanks in advance for any suggestions.