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



      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