Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to set the Presentation to Horizontal in a macro. Is there a published list of property references? After I use the GetProperties statement I do't know how to reference the Presentation > Horizontal property
Ah got it.
set chart = ActiveDocument.GetSheetobject("CH01")
set cp = chart.GetProperties
cp.TableProperties.Horizontal = true
chart.SetProperties cp
'chart.SetPixWidths_Horizontal true,200
'chart.SetPixWidths_Horizontal false,150
Hi Hanief,
set chart = ActiveDocument.GetSheetobject("CH01")
set p = chart.GetProperties
p.ChartProperties.Horizontal = true
chart.SetProperties p
Thanks Tamil. That's seems to be correct. I am not getting any errors, but the straight table is not flipping when I run this.
Ah got it.
set chart = ActiveDocument.GetSheetobject("CH01")
set cp = chart.GetProperties
cp.TableProperties.Horizontal = true
chart.SetProperties cp
'chart.SetPixWidths_Horizontal true,200
'chart.SetPixWidths_Horizontal false,150
Thank you! The change from ChartProperties to TableProperties works.
Great. Have a super day!