Adding a text box to XL chart from Access 1

[kndavies]

Hi,
Using Office 2000
I need to add a text box to an Excel chart, code running in Access but all I get is the "Object doesn't support this property or method" error.

Code is:

With xlsApp.Application
<working code>

.ActiveChart.Shapes.AddTextbox(xmsoTextOrientationHorizontal, 566.88, 65, 111, 30).Select

<working code>

end with

Code needs debugging at the AddTextbox point.

I have been playing with this on and off for days now - please put me out of my misery!
Ken

 

[SkipVought]

Hi,

If the chart is a Chart Sheet, as opposed to a chart embedded in a worksheet, the only control objects available are Form control objects instead of Control Toolbox control objects.



Skip,

http://www.TheOfficeExperts.com

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884