Word 2010 Web Toolbar

[bjg1]

Is there anything in Office 2010 that replaced the Web Toolbar, where you could find the full path and filename.

We are just moving to Office 2010 and have had many requests for the path and filename that can be copied to use for hyperlinks. Our documents could be local, on the WAN or on SharePoint.

We know that in most of the Office products we can insert the path and filename fields, but not all types of documents will have the path and filename in the document. Is there anyother way to easily get the information so it can be copied to use in another application?

[Charles Kenyon]

I think you are the first person I've heard of actually using the web toolbar! There are whole pages written about how to get rid of it. However, you point out one function for which there isn't a ready substitute.

Inserting a field with the information you need and then converting that field to text will let you copy the filename and path anywhere you want.

You can type "FileName \p" in a document and select it (no quotation marks), press Ctrl F9 to make it into a field and then F9 to activate it. You can then select this and make it a building block. When you use it in a document, selecting it and pressing Ctrl-6 will give you text of the filename and path.

Sorry so convoluted.

[jscher2000]

You could try a macro that accesses the contents of the Web toolbar under the covers:

Sub ShowAddress()
Dim strTemp As String
strTemp = InputBox("This is the URL from the Web toolbar", "Excavated!", _
  ActiveDocument.CommandBars("Web").FindControl(ID:=1740).Text)
End Sub

[Charles Kenyon]

You could try a macro that accesses the contents of the Web toolbar under the covers...

I suppose this is something others may want to know, so I've taken the liberty of adding it to my FAQ page on the web toolbar. http://www.addbalance.com/word/webtoolbar.htm

If you would like me to remove it or attribute it to you please let me know.

[bjg1]

This works for me in Word 2010. You wouldn't be chance have the same macro for Excel and PowerPoint?

[jscher2000]

You wouldn't be chance have the same macro for Excel and PowerPoint?

For Excel, you substitute Application for ActiveDocument:

Sub ShowAddress()
Dim strTemp As String
strTemp = InputBox("This is the URL from the Web toolbar", "Excavated!", _
  Application.CommandBars("Web").FindControl(ID:=1740).Text)
End Sub

I don't have time at the moment to test PowerPoint. Does that work for PowerPoint as well?

[Charles Kenyon]

Text is not a property of .FindControl(ID=1740) in PowerPoint.
Not sure I am using the proper terms but it won't work in PowerPoint.

[jscher2000]

That code runs for me in PowerPoint, but there is a problem. Because it looks at the web toolbar in the context of the overall application, it doesn't necessarily returns the path to the active file, but instead the last opened or, if later, the file last edited (even if not saved). This inconsistency is troubling; I can't really trust the results.

Something along the following lines hopefully is more useful:

PowerPoint:

Sub ShowPathAndName()
Dim strTemp As String
strTemp = InputBox("This is the FullName of the ActivePresentation", "Excavated!", ActivePresentation.FullName)
End Sub

While Excel seems to handle the original function consistently, I think this is safer:

Excel:

Sub ShowPathAndName()
Dim strTemp As String
strTemp = InputBox("This is the FullName of the ActiveWorkbook", "Excavated!", ActiveWorkbook.FullName)
End Sub

And finally for Word, why not, for the sake of consistency:

Word:

Sub ShowPathAndName()
Dim strTemp As String
strTemp = InputBox("This is the FullName of the ActiveDocument", "Excavated!", ActiveDocument.FullName)
End Sub

bjg1, does that work for your documents (I don't have SharePoint to test)?

[bjg1]

Sorry that it took me so long to get back to you. We have been rolling out Office 2010 to our staff.

Each of the modules works for me in 2010. Thank you.

[bjg1]

One of our members found the command "Document Location" which we can add to the QAT to give use the path and filename.

[jscher2000]

One of our members found the command "Document Location" which we can add to the QAT to give use the path and filename.

That looks suspiciously like the URL drop-down from the Web toolbar. Excellent find.