Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
hope you got the answer from Anil babu