Macro to Hide column and expand

[#1]

Hi Everyone,

I am Exporting a table to excel from qlikview, Iam using

Columns("L1:P1").EntireColumn.Hidden = True

to hide the column in exported excel,

But this is not working.

Please help me on below issue.

Thanks in advance

Regards,

Harika.

[Anil_Babu_Samineni]

Tested Done !!

FUNCTION HideColumn(ch, n)
set ch = ActiveDocument.GetSheetObject(ch)
ch.SetPixWidth (n-1),0
set ch = Nothing
END FUNCTION

SUB ColHide
call HideColumn("CH01", '2')
END SUB

sub Anil
ActiveDocument.ClearCache
MSGBOX "OK Cache"
END SUB

[tajmohamed30]

hope you got the answer from Anil babu