Results 1 to 2 of 2

Thread: Embedded Object "Management"

  1. #1
    VBAX Expert
    Feb 2005

    Embedded Object "Management"

    further to my earlier thread about displaying embedded objects via VBA ...

    Thanks to Jon's help , I was able to develop a pretty useful embedded object display procedure. Given the possibility of multiple objects on a sheet, the procedure uses the object's name to find the right object. Changing the object's name is pretty simple, and useful names are certainly preferred over things like "Object 5". Changing the "path\name" displayed as part of the object icon is more difficult. It is mostly cosmetic, but I would like to clean up this approach. Anyone know how to change that?

    NOTE: when an object is initially inserted and the "display as icon" method is selected, you can change the icon caption or label via the "Change Icon" button. This accomplishes what I want to do. But assuming that you already have the object inserted, how do you change the icon's caption or label?

    Also, I have looked through the OLEobject properties list and can not find anything related to the original or native application. For, say, a Word document embedded in Excel, OLEObject.Parent.Name is the owning worksheet and OLEObject.Application is Excel. Original appl info must be there else how would Excel know what appl to spawn to open the object. Any help would be appreciated.
    "It's not just the due date that's important, it's also the do date" [MWE]

    When your problem has been resolved, mark the thread SOLVED by clicking on the Thread Tools dropdown menu at the top of the thread.

  2. #2
    VBAX Master Killian's Avatar
    Nov 2004
    I'm not sure if the IconLabel property is exposed to the object model outside the Add method... I'll have a dig around.
    Regarding the Object's application type, this is stored in it\s ProgID property[VBA]Dim objOLE As OLEObject

    For Each objOLE In ActiveSheet.OLEObjects
    Debug.Print objOLE.progID
    K :-)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts