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

  • Question

  • "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

  • 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

  • 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
  • Did you get any solution for this?
    Friday, April 6, 2012 10:56 AM