Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Word 2010 Web Toolbar

    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?

  2. #2
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Madison, Wisconsin, Wisconsin, USA
    Posts
    1,701
    Thanks
    56
    Thanked 63 Times in 61 Posts
    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.
    Charles Kyle Kenyon
    Madison, Wisconsin

  3. #3
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    You could try a macro that accesses the contents of the Web toolbar under the covers:

    Code:
    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

  4. #4
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Madison, Wisconsin, Wisconsin, USA
    Posts
    1,701
    Thanks
    56
    Thanked 63 Times in 61 Posts
    Quote Originally Posted by jscher2000 View Post
    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.
    Charles Kyle Kenyon
    Madison, Wisconsin

  5. #5
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    This works for me in Word 2010. You wouldn't be chance have the same macro for Excel and PowerPoint?

  6. #6
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by bjg1 View Post
    You wouldn't be chance have the same macro for Excel and PowerPoint?
    For Excel, you substitute Application for ActiveDocument:

    Code:
    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?

  7. #7
    Silver Lounger Charles Kenyon's Avatar
    Join Date
    Jan 2001
    Location
    Madison, Wisconsin, Wisconsin, USA
    Posts
    1,701
    Thanks
    56
    Thanked 63 Times in 61 Posts
    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.
    Charles Kyle Kenyon
    Madison, Wisconsin

  8. #8
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    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:
    Code:
    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:
    Code:
    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:
    Code:
    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)?

  9. #9
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    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.

  10. #10
    3 Star Lounger
    Join Date
    Aug 2003
    Location
    Green Bay, Wisconsin, USA
    Posts
    396
    Thanks
    4
    Thanked 0 Times in 0 Posts
    One of our members found the command "Document Location" which we can add to the QAT to give use the path and filename.

  11. #11
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts
    Quote Originally Posted by bjg1 View Post
    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.

  12. The Following User Says Thank You to jscher2000 For This Useful Post:

    pdk111 (2012-03-12)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •