Embed Add-in In A Word Document

  • Hi all,

    I've just written up an SOP for a reconciliation process. Part of it requires the reader to use some Excel UDFs that I've created. Rather than having someone look for the UDF file on the network, I tried to embed it as an Excel Worksheet Icon within my procedure document. However, when I double-click the icon to launch the add-in, I get the following error message:

    "Microsoft Word can't start the application required to open this object. An error occurred and this feature is no longer functioning properly. Would you like to repair this feature now?"

    This does not happen when I embed a regular Excel workbook, or even a template.

    Would appreciate some help on this.



  • Re: Embed Add-in In A Word Document

    mhabib, where does MS Word come into the question.

    For an addin to work, it must be installed by using Tools menu > Addins and browsin for it. AFAIK, you can't just embed it into a sheet.

  • Re: Embed Add-in In A Word Document

    Can not see this working uless You mean taking the XLAs code from the XLA and putting that code into the XLS, which could get complicated and needs some reJigging I am guessing?

    Any User forum You could pull over, but again reJigging the code will be required


  • Re: Embed Add-in In A Word Document

    Hello Jack,

    I would like my Add-in to follow the Word document that I've created. In other words, I do not want to refer to a network location for my Add-in that may become invalid in future.

    The advantage of doing it this way is that whoever takes over the task after me will receive a Word document containing the procedural instructions for the task, along with the necessary UDF. When I took over this task, I got the instructions as Word attachment via email, and that's how my successors will get it as well.

    Given the constraints, I guess the only option available to me is to place the add-in on the network and provide reference to it in the word file.

    BTW, I can access my UDFs by simply double-clicking the add-in's Icon - i.e., no need to go to Tools > Add-ins. I was hoping the same strategy would work for the next person taking over the task.

    Thanks for your feedback.


  • Re: Embed Add-in In A Word Document

    They are Your option I guess or add the code inside the Word document so its all there, Your call, as for following the Word doc erm nope that stays put so the others need the same access rights on the network for this to work


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!