P
pamela
How can I create a chart via VBA? I am trying to use
Dim ResponseChart as Control
Set ResponseChart = CreateReportControl(NewReport.Name,
acObjectFrame, acGroupLevel1Header, , , 4680, 3120, 5026,
765)
This creates an Unbound Object Frame, what I am trying to
create is a Chart. I can use this method for textboxes,
labels, lines, and rectangles; but I am not able to
successfully create a chart.
Please point me in the right direction. Thank you.
Dim ResponseChart as Control
Set ResponseChart = CreateReportControl(NewReport.Name,
acObjectFrame, acGroupLevel1Header, , , 4680, 3120, 5026,
765)
This creates an Unbound Object Frame, what I am trying to
create is a Chart. I can use this method for textboxes,
labels, lines, and rectangles; but I am not able to
successfully create a chart.
Please point me in the right direction. Thank you.