topic Re: Remove sheet object VBScript in QlikView

Remove sheet object VBScript

Sun, 29 Jun 2014 15:16:20 GMT

How to remove/delete a sheet object with given name in VBscript ?

I would like to loop over all sheet objects, find its name, and delete it if the name equals some given value ,.

robert_mika — Sun, 03 May 2015 23:13:09 GMT

Old topic but if someone are looking for a similar solution....

This macro will remove object based on user input

Sub DeleteObject

set s=ActiveDocument.Sheets("Main")

name = ActiveDocument.GetApplication.InputBox("Enter name of the object?")

Objects = ActiveDocument.ActiveSheet.GetSheetObjects

For j = lBound(Objects) To uBound(Objects)

set obj = Objects(j)

IF obj.GetCaption.Name.v = name Then

s.SheetObjects(j).Close

else

end if

End Sub

Wed, 25 May 2016 18:46:45 GMT

Hi Robert

Thank you very much!

It will help me a lot !

Regards