add dimension on macro at 9.0

[#1]

Does not work chart.AddDimension script on updated 9.0 from 8.5. It was OK if described AddExpression followed by AddDimension on 8.5. But niether order expression and dimension does not work on 9.0. Is there any new API example to solve this chart property setting?

[#2]

in 9.0, it's not possible to access/modify a sheet object which doesn't belong to the active sheet, nor a minimized one

also, some methods do not fail when trying to do that, but return wrong values (for example GetRowCount, GetTableAsText behave this way)

[#3]

Thank you for your advice.

still works on adding expressions for expample

set chart2 = ActiveDocument.ActiveSheet.CreateStraightTable
chart2.AddExpression "SUPPLIERNAME"

You mean no more support on CreativeStraigntTable ?

[#4]

You should be able to add a dimension to your straight table box if it is in the currently active sheet

adding expression is possible even if the sheet isn't the active one