Export hidden column to xls

[#1]

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

[#2]

no one

[salto]

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!

[israrkhan]

Hi

write a macro, in which first unhide(show) the column,

then export command,

then again hide the column....

all through macro...

[#5]

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?

[salto · Accepted solution]

Try with this one and let me know if it works...

Hope this helps!

[#7]

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