Does anyone have any sample code of hiding a column using OLE2. I am using the following code, but it doesn't seem to be working...
args := OLE2.CREATE_ARGLIST
OLE2.ADD_ARG ( args, 'A:A' );
column:=OLE2.GET_OBJ_PROPERTY(worksheet, 'Columns', args );
OLE2.DESTROY_ARGLIST ( args );
OLE2.SET_PROPERTY ( column, 'Hidden', True );
OLE2.RELEASE_OBJ ( column );
Any help you could give me would be much appreciated!!
Thanks In Advance...
args := OLE2.CREATE_ARGLIST
OLE2.ADD_ARG ( args, 'A:A' );
column:=OLE2.GET_OBJ_PROPERTY(worksheet, 'Columns', args );
OLE2.DESTROY_ARGLIST ( args );
OLE2.SET_PROPERTY ( column, 'Hidden', True );
OLE2.RELEASE_OBJ ( column );
Any help you could give me would be much appreciated!!
Thanks In Advance...