Excel plot generated in Ms Acess 97 - small problem

K

Kamyk

Hello all!

I have a problem with using a plot in MS Access 97.
I have generated a Excel plot using a visual basic code in MS Access 97.
Why doesn`t this below code work?

ActiveChart.PlotArea.Select
ActiveChart.ChartArea.Select
ActiveChart.Location Where:=xlLocationAsObject, Name:="Sheet3"

Default plot generating locate this plot on Sheet1, but I want this plot to
be draw on Sheet3. I think it is impossible to do it in MS Access 97.
Can you help me why this above code doestn`t work in MS Access 97 and why
this activechart.location completely doesn`t work in Access 97?

Thank you in advance
Marcin from Poland
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

chart and automation error 5
Help: 1004 Method 'Charts' of Object '_Global' failed 3
Problems migrating from EXcel 97 to Excel 2003 0
Problem with footer data with Excel 2003 and 2007 0
Problem with sending appointment 1
problems saving 0
MS Chart (In Access) Programming Problems 0
Removing unnamed Legend lines from an Excel template 4

Top