Remove columns from tablebox

jagannalla — Tue, 16 Aug 2011 07:42:14 GMT

Hi,

I've a different number of fields in tablebox when i click the button i want to remove the columns from 2nd column of table box every time. The below code is not working what i want. Can anyone help me.

sub RemoveField

set TB = ActiveDocument.GetSheetObject("TB34")

for i = 2 to GetColumnCount

'msgbox i

TB.RemoveField i

end sub

Remove columns from tablebox

jagannalla — Tue, 16 Aug 2011 08:05:15 GMT

Sorry..

I got myself solution for this..Just i need to add in the above code like this...

-- >TB.RemoveField 2

sub RemoveField

set TB = ActiveDocument.GetSheetObject("TB34")

for i = 2 to TB.GetColumnCount

'msgbox i

TB.RemoveField 2

end sub

topic Remove columns from tablebox in QlikView

Remove columns from tablebox

Remove columns from tablebox