Free Republic
Browse · Search
General/Chat
Topics · Post Article

Skip to comments.

Can I switch to a "folder" view of an open MS Office file?
self

Posted on 01/25/2006 4:26:39 AM PST by rudy45

I have an open MS Office file (e.g. Word document, Excel spreadsheet, PowerPoint presentation). I would like to see the graphical location of this file, using Windows Explorer. Is there a command I can use within that Office application that brings up, within Explorer, the location of that file? I know I can click on File/Properties, but then I have to remember the sequence of folders, then manually look it up via Explorer (which is a nuisance). I was hoping there's some way of zooming right to that location.

I would need this capability, for example, if I wanted to burn the file to a CD. Thanks.


TOPICS: Computers/Internet
KEYWORDS: computer; msoffice; windowsexplorer

1 posted on 01/25/2006 4:26:40 AM PST by rudy45
[ Post Reply | Private Reply | View Replies]

To: rudy45
Which OS?


This is a ch__ch. What's missing?

2 posted on 01/25/2006 4:28:38 AM PST by rdb3 (What it is is what it was.)
[ Post Reply | Private Reply | To 1 | View Replies]

To: rdb3

XP Home, Word 2002


3 posted on 01/25/2006 4:29:17 AM PST by rudy45
[ Post Reply | Private Reply | To 2 | View Replies]

To: rudy45
Right-click the file, then choose 'Properties.' It will tell you the location.

Next, all you have to do is left-click and drag to highlight the entire directory tree. Do as you wish with it since it's now on your clipboard.


This is a ch__ch. What's missing?

4 posted on 01/25/2006 4:35:20 AM PST by rdb3 (What it is is what it was.)
[ Post Reply | Private Reply | To 3 | View Replies]

To: rudy45

In Word, click File -> Properties, go to the General tab. Highlight the location, then press control-c to copy it to the clipboard. Now click Start -> Run, and paste into the "open" box, and click OK. The folder should then open for you.


5 posted on 01/25/2006 4:35:48 AM PST by BubbaTheRocketScientist
[ Post Reply | Private Reply | To 1 | View Replies]

To: BubbaTheRocketScientist

Thanks, it worked.

I really appreciate it.

Is this the only way? There's no "view in folder" option?

Thanks.


6 posted on 01/25/2006 4:42:40 AM PST by rudy45
[ Post Reply | Private Reply | To 5 | View Replies]

To: rudy45

If you used File>Open to open the current doc then clicking File>Open again should take you to that same containing folder by default, I think. now if you just browsed explorer for it to open it and not opened it from within office, I dont think that will work initially. There is no "folders view" button like in windows explorer but you can probably find a 3rd party add on, or maybe ms makes one. Interesting, I may look for one as well.


7 posted on 01/25/2006 4:51:34 AM PST by RedBloodedAmerican
[ Post Reply | Private Reply | To 6 | View Replies]

To: rdb3

My, my, my.... Look who's the Windows expert around here!!!

Now if you ansered a Mac question like this, I'd have to worry about you!

:-)


8 posted on 01/25/2006 4:54:04 AM PST by Incorrigible (If I lead, follow me; If I pause, push me; If I retreat, kill me.)
[ Post Reply | Private Reply | To 4 | View Replies]

To: Incorrigible
Hey, don't hate the playa. Hate the game! :-P


This is a ch__ch. What's missing?

9 posted on 01/25/2006 4:57:19 AM PST by rdb3 (What it is is what it was.)
[ Post Reply | Private Reply | To 8 | View Replies]

To: rudy45
That's the only way I know to do it; I don't know of any built-in word function that will do what you want.

Thanks.
You're welcome!
10 posted on 01/25/2006 5:24:23 AM PST by BubbaTheRocketScientist
[ Post Reply | Private Reply | To 6 | View Replies]

To: rudy45
Here's a (relatively) simple way to make a toolbar button to do what you want.

Click tools -> macro -> macros
In the "macros in" combo box select Normal.dot (global template). In the Macro Name box put OpenExplorerWindow and click create. The VBA editor should pop up with an empty function definition created for you.

Paste the following code into the empty function:
      Dim objShell
      Dim objFolder
      Dim strDir
      strDir = Word.Documents.Item(1).Path
      Set objShell = CreateObject("Shell.Application")
      objShell.Explore (strDir)


Now click the "save" button in the VBA editor, that should save the new macro in normal.dot so you can access it from any Word document.

Close the VBA editor and go back to Word. Click View -> Toolbars -> Customize, then click the Commands tab. In the Categories listbox, click "Macros", then find "Normal.NewMacros.OpenExplorerWindow" in the Commands listbox. Click and drag Normal.NewMacros.OpenExplorerWindow from that listbox and drop it onto one of your toolbars.

You should now have a button which, when clicked, opens a Windows Explorer window showing the location of the current document.
11 posted on 01/25/2006 5:49:48 AM PST by BubbaTheRocketScientist
[ Post Reply | Private Reply | To 6 | View Replies]

To: BubbaTheRocketScientist

You, sir, are a genius.

Another way is to do a file open, then click on "recent." The file I am working with should show up at or near the top of the list. At that point, simply drag and drop it.

Thanks again.


12 posted on 01/25/2006 6:22:07 AM PST by rudy45
[ Post Reply | Private Reply | To 11 | View Replies]

To: rudy45

I'm not sure if this is going to help you, but I have a link to "My Docs" included in MS Internet Explorer. When I click the link, everything in it is opened in a page that shows the path to each doc.


13 posted on 01/25/2006 6:25:17 AM PST by Nasty McPhilthy (Those who beat their swords into plow shears….will plow for those who don’t.)
[ Post Reply | Private Reply | To 1 | View Replies]

Disclaimer: Opinions posted on Free Republic are those of the individual posters and do not necessarily represent the opinion of Free Republic or its management. All materials posted herein are protected by copyright law and the exemption for fair use of copyrighted works.

Free Republic
Browse · Search
General/Chat
Topics · Post Article

FreeRepublic, LLC, PO BOX 9771, FRESNO, CA 93794
FreeRepublic.com is powered by software copyright 2000-2008 John Robinson