The code below just creates a doc file which puts a excel chart on the doc file but the probelm is how do i change the chart type and give data for the chart to plot
Dim letters As New Word.Application
Dim letterdoc As New Word.Document
Set letterdoc = letters.Documents.Add
.Selection.TypeText "Total closed tickets by priority"
Set letterdoc = Nothing
Set letters = Nothing
this is what i wanna do but how do i do it???
i tried to use record the macro but somehow it wont work
plz help me!!