dimanche 29 mars 2015

Use MS Word VBA to increase weight of axes in graph embedded in a Word document

I am able to control the weight of a graph in Excel VBA using the following code:



ActiveChart.Axes(xlCategory).Select
With Selection.Border
.ColorIndex = 57
.Weight = xlMedium
.LineStyle = xlContinuous
End With


When I try running this in Word VBA, I get the error


Compile error: Method or data member not found.


.Border is highlighted.


I experimented with the code



salesChart.Axes(xlCategory).Select
Selection.Borders(wdBorderBottom).Visible = True


and got the message


Run-time error '4605' This method or property is not available because the object refers to a drawing object.


I want to figure out a way to highlight the axes in the graph I'm embedded in a MS Word document through Word VBA


Aucun commentaire:

Enregistrer un commentaire