Changing order Column Table

[emteam162]

Hi All,

Existe any way to change order column Straight table dynamic by macro ....

i have build my table dynamic and i want to show column straight table by order what i want.

Many thanks for your help.

Best Regards,

Emteam

[Gysbert_Wassenaar]

Use the MoveExpression and MoveDimension members of the StraightTableBox object.

Example from the apiguide qvw:

rem create new straight table and switch places of expression columns

set chart = ActiveDocument.Sheets("Main").CreateStraightTable

chart.AddDimension "ProductType"

chart.AddExpression "sum(Amount)"

chart.AddExpression "count(Product)"

chart.MoveExpression 1,0

[emteam162]

Hi,

Thanks for your answer.

I'll try your solution .

Best Regards,

Emteam

[emteam162]

Hi Gysbert Wassenaar

Could you please help me to do loop

I have ListBox (Name of my All Expression) my idea is when a select value from this listbox i bluid straigth table

ListBox Name of expression

D

E

G

M

Q

When i select by order in my listBox D,G,M i will have this table

Dimension	D	G	M
AA	1	2	3
BB			0
CC	89	42	0
DD	123	125	15

Many thanks for your help

Emteam