-
Re: Delete Object VBS
Gysbert Wassenaar Feb 28, 2013 7:36 AM (in response to Micael Leal)You need to use the close() member:
rem ** remove all sheet objects on sheet Main **
set s=ActiveDocument.Sheets("Main")
orignumber=s.NoOfSheetObjects
for i=0 to orignumber-1
s.SheetObjects(0).Close
next
-
Re: Delete Object VBS
Micael Leal Feb 28, 2013 8:09 AM (in response to Micael Leal)Hello,
Thanks for the quick reply.
It deletes all Objects from the Sheet.
But with a bit of adaptation I figured out the rest and this link:
http://community.qlik.com/thread/3177
'Delete Previous Chart
rem ** remove one sheet object on sheet Main **
set s=ActiveDocument.Sheets("Main")
orignumber=s.NoOfSheetObjects
for i=0 to orignumber-1
rem ** get unique object ID for given object on sheet **
set so = s.SheetObjects(i)
id = so.GetObjectId
'Prints all objects ids on the current sheet
'msgbox("ID = " & id)
'Prints Table ID
IF id = "Document\Table" THEN
'TableBox to be deleted
s.SheetObjects(i).Close
END IF
next