Excel 2007 - File Path location
Hi
In old excel the web toolbar used tell me the file location including the details of the server. Now however for both the location tab and formula =cell("filename") return the file path without the server detail ie it shows the drive I have mapped it to on my computer. I prefer the server details as I can send this link to other people who can find the file regardless what drive they have mapped the server to. Any quick fix to display the server details instead of directory detail thanks -- Kevin |
Excel 2007 - File Path location
First, it's always a good idea to include a reference to the worksheet/workbook
in that formula: =cell("filename",a1) (I use the cell that contains the formula) If you don't use it, then the formula will return the name of the workbook/worksheet that was active when excel recalculated. Second, (and I don't have access to a network share to test), but I thought that you'd see whatever you used to open the file. If you opened it from the mapped drive, then you'll see the mapped drive letter. But if you opened it from the shared drive, you'll see the \\server\path stuff. ==== But there are ways of translating between mapped drives and UNC paths. I searched google for: vba mapped drive unc path And found a hit from Rob Bovey: http://groups.google.co.uk/group/mic...25028147e02 6 or http://snipurl.com/3v5dx Kevin wrote: Hi In old excel the web toolbar used tell me the file location including the details of the server. Now however for both the location tab and formula =cell("filename") return the file path without the server detail ie it shows the drive I have mapped it to on my computer. I prefer the server details as I can send this link to other people who can find the file regardless what drive they have mapped the server to. Any quick fix to display the server details instead of directory detail thanks -- Kevin -- Dave Peterson |
All times are GMT +1. The time now is 02:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com