Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi all
I've been searching and I know how to conditionally hide/show
but yet to include it when users click the export to XLS button.
i need a macro to xls that includes hidden columns
i tried with :
set obj = ActiveDocument.GetSheetObject("CH02")
obj.SendToExcel
but it doesn't work for hidden columns
Can u help me pls?
Ty
no one
Hi,
you could set a variable (let's say vShow) which is initialized as 0.
The column(s) you want to hide should have the value =$(vShow)=1 in the Conditional field, Expressions tab of the object. This way the column is hidden.
To export the chart to with the hidden column, place the macro between the two actions of the "Export with hidden column" button.
Hope this helps!
Hi
write a macro, in which first unhide(show) the column,
then export command,
then again hide the column....
all through macro...
Sorry but it's my first macro
the hidden columns are B-C-D
set obj = ActiveDocument.GetSheetObject("CH02")
unhide(show)
obj.SendToExcel
hide(show)
it's right?
Try with this one and let me know if it works...
Hope this helps!
Hi,
i created variable vShowColumn
This macro doesn't export hidden column :
vShowColumn=1
set obj = ActiveDocument.GetSheetObject("CH02")
obj.SendToExcel
vShowColumn=0
where is the error?
tyvm