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.

Thanks

m

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.

m