How to modify the label of embedded-object icon in Excel

**Omkaari** · 24-01-2012

I inserted a Microsoft Word file as an object on a worksheet, displayed as an icon. The icon is labeled "Microsoft Word Document." I would like to give it a more descriptive name, but could not figure out how. Selecting the icon shows in the formula bar: =EMBED("Word.Document.8",""). Trying to change the text between either pair of quotation marks gave me the error message "The text you entered is not a valid reference or defined name." How do I change the label of the embedded-object icon?

**Shurod** · 24-01-2012

When you insert the object, select the "Create from file" tab, then check both "Link to file" and "Display as icon" . Then you can use the "Change Icon" button, and edit the caption.
Change the way a linked or embedded object is displayed
Insert information by creating a linked object or embedded object

**Erakna** · 24-01-2012

Embedding as a file object in a document (as an excel spreadsheet) that the application is NOT "the object" is necessary to "return" to a location where your application can manage (access or machinery for consultation) this can make your client (by hand) .
Selecting the embedded object > Copy it (ctrl + C). And paste it into Windows Explorer (the folder obviously "Corresponding") or you can try a macro that includes instructions + / - as following:

Code:

 activesheet.oleobjects ("name of the embedded object.") copy 
 createobject ("Shell.Application.") namespace (active workbook.path). self.invokeverb "paste"