1 Reply Latest reply: Jun 1, 2011 10:11 PM by Erich Shiino RSS

    Get object name for each sheet object

      Hi Again

       

      Now I'mplaying with adding aand removing objects

       

      this script is totally wrong, but it gives you an insight on what I am tryiong to do - I've done it in VBa in excel, but ....

       

      for each shobj in sheetobjects
           set box=shobj.GetProperties
           objName = box.ObjectId
           msgbox objName
      next

       

       

      In otherwords, I want to prove I can capture the objectID. THat way I can delete objects that I dont want

      i.e. if object name <> "myobject" then delete kind of thing

      Again assistance please