By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,441 Members | 996 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,441 IT Pros & Developers. It's quick & easy.

Excel Chart automation through Access

P: 5
I am developing a small routine that exports data from an Access database to Excel and plots a chart.

At this stage the routine successful exports the data to excel but I am having a problem with the chart plotting part.

Even though the code for generating the plot is fine, the routine does not like some chart required parameters such as

.Axes(xlCategory, xlPrimary)
.ChartType=xlXYScatter

and the like. I need to plot a scattered graph and need to state the parameters with out which I am getting a bar chart.

I believe I have set ticked all the references required which are listed below.

1) Visual Basic for Application
2) Microsoft Access 11.0 Object Library
3) OLE Automation
4) Microsoft DAO 3.6 Object Library
5) Microsoft ActiveX Data Objects 2.1 Library
6) Microsoft Office web components 11.0
7) Microsoft Office XP Web Components
8) Microsoft forms 2 Object Library
9) Microsoft ADO Ext 2.8 for DDL and Security
10) Microsoft Excel 11.0 Object Library

I have, however, a missing Macrobrowser and I was not able to restore it or find any information about.

I would appreciate it if u could give me an idea as to what is happening.

Thanks
Mar 12 '07 #1
Share this Question
Share on Google+
5 Replies


100+
P: 1,646
Are you doing this in access, vb or vb.net?
Mar 12 '07 #2

P: 5
No I am doing it in Access and populating the Excel sheet
and ploting in Excel
Mar 12 '07 #3

100+
P: 1,646
Then off we go to the access forum
Mar 12 '07 #4

P: 5
Oh Sorry I didn't know I will repost it in the Access forum
Mar 13 '07 #5

100+
P: 1,646
Oh Sorry I didn't know I will repost it in the Access forum
You don't need to. I have moved the thread.
Mar 13 '07 #6

Post your reply

Sign in to post your reply or Sign up for a free account.