Export straight table with hidden column

[sibin_jacob]

Hi,

Is it possible to export straight table with hidden column?

Is this possible to achieve this functionality using macro?

Thanks,

Sibin Jacob.C

[#2]

yes

macro :

-unhide column

-export

-hide column

[sibin_jacob]

Thanks Pari... Its helped me to solve the issue...

[#4]

Hi, may u explain me how?

i tried :

set obj = ActiveDocument.GetSheetObject("CH02")

obj.Unhide

obj.SendToExcel

but it doesn't work

ty

[sibin_jacob]

Hi simone,

Below are the steps to export straight table with hidden columns.

1. create a new variable (vTest).

2. create new text object ( add text as Export)

3. add a action into that text object (

     a. use set variable trigger -> set the variable value into 1

     b. user run macro trigger)

4. In the straight table, show/enable the hidden expression when the variable value is 1

5.Use the macro to export the straight table

6. At the end of the macro, change the variable value into 0.

below is the line of macro for change the variable value.

ActiveDocument.Variables("vTest").SetContent 0,true

I hope this helps! Let me know if you need additional details.

Thanks,

Sibin Jacob. C