locked
Showing linked doc names into the Word 2010 customised Tab in Ribbon RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    "Hi, I have lots of links in my MS Word 2010 document to other Office documents like Excel.  Is there any way that I can place these names (about 4 of them) into a section on my customised Ribbon tab, this would make it so much easier to 'jumlp to' these linked documents rather than have to look for the linked text and then Ctrl Click.  Any help or advice would be very much appreciated.  Mary
    Thursday, April 5, 2012 12:30 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    As this issue, first we can create some macros to open the files. The code is following:

    Sub openExcel1()

    Dim xlApp

     Set xlApp = CreateObject("Excel.application")

     xlApp.Visible = True

     xlApp.workbooks.Open "C:\Book1.xls"

    End Sub

    Note: please change the path of the file in the code.

    Then click File tab->Options->Customize Ribbon.

    In the right, choose Macros in the “Choose commands from:” .In the “Customize the Ribbon:” part, click “New Tab” button, rename the tab and the Group, then Add the macros to the Group.

    Jaynet Zhang

    TechNet Community Support

    • Marked as answer by Jaynet Zhang Tuesday, April 10, 2012 7:41 AM
    Friday, April 6, 2012 2:04 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi,

    As this issue, first we can create some macros to open the files. The code is following:

    Sub openExcel1()

    Dim xlApp

     Set xlApp = CreateObject("Excel.application")

     xlApp.Visible = True

     xlApp.workbooks.Open "C:\Book1.xls"

    End Sub

    Note: please change the path of the file in the code.

    Then click File tab->Options->Customize Ribbon.

    In the right, choose Macros in the “Choose commands from:” .In the “Customize the Ribbon:” part, click “New Tab” button, rename the tab and the Group, then Add the macros to the Group.

    Jaynet Zhang

    TechNet Community Support

    • Marked as answer by Jaynet Zhang Tuesday, April 10, 2012 7:41 AM
    Friday, April 6, 2012 2:04 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Did you get any solution for this?
    Friday, April 6, 2012 10:56 AM