如何轻松获取您正在处理的文件的网路？ [英] How to easily get network path to the file you are working on?

问题描述

在Excel 2003中，曾经有一个命令，我添加到我的工具栏中被称为地址（如果我记得正确），它将显示我已经打开的文件的完全限定的网络路径。例如： \\ads\IT-DEPT-DFS\data\Users\someguy\somefile.xls

In Excel 2003 there used to be a command that I added to my toolbar that was called Address (if I remember correctly) and it would show the fully-qualified network path to the file I had open. For example: \\ads\IT-DEPT-DFS\data\Users\someguy\somefile.xls

当您想与同事共享文件时，可以轻松抓取此字符串并将其弹出电子邮件。我在Excel 2010中看不到这个选项，但是发现自己现在需要发送/接收Excel文件。工作人员将会提供它在共享驱动器上的模糊的引用，或者以附件的形式发送文件（呃！）。

This made it easy to grab this string and pop it in an email when you wanted to share the file with a coworker. I don't see this option in Excel 2010 but find myself needing to send/receive Excel files a lot now. Coworkers will give vague references to "it is on the share drive" or email the file as an attachment (ugh!).

任何人都知道Excel 2010中是否存在可比性？

Anyone know if something comparable exists in Excel 2010?

更新：我发现Excel 2003到2007命令的映射。 http://office.microsoft .com / en-us / excel-help / redir / AM010186429.aspx？CTT = 5& origin = HA010086048

UPDATE: I found this mapping of Excel 2003 to 2007 commands. http://office.microsoft.com/en-us/excel-help/redir/AM010186429.aspx?CTT=5&origin=HA010086048

Web>地址是我使用 - 看起来像2007年成为文档位置。但是他们在2010年再次删除/混淆了这一点。我试图在2007年至2010年期间找到这样的映射。

Web>Address is what I was using - looks like that became "Document Location" in 2007. But they removed/obfuscated this again in 2010. I am trying to find a mapping like this for 2007 to 2010.

推荐答案

回答我自己的问题。我发现，唯一的方法是一贯和即时的工作是：

Answer to my own question. The only way I have found that works consistently and instantaneously is to:

1）在我的收藏夹中创建一个链接到我使用的目录

1) Create a link in my "Favorites" to the directory I use

2）将该收藏夹的属性更新为绝对路径（\\\\\ DIT-DFS\Data\MAILROOM）

2) Update the properties on that favorite to be an absolute path (\\ads\IT-DEPT-DFS\Data\MAILROOM)

3）保存新文件时，只能通过上面创建的收藏夹目录导航到该目录（或者可以使用绝对路径的任何快捷方式）

3) When saving a new file, I navigate to that directory only via the Favorites directory created above (or you can use any Shortcut with an absolute path)

4）保存后，进入文件选项卡，完整路径可以从信息（默认）部分的顶部复制

4) After saving, go to the File tab and the full path can be copied from the top of the Info (default) section

这篇关于如何轻松获取您正在处理的文件的网路？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！