Improve company productivity with a Business Account.Sign Up

x
?
Solved

export mschart to excel

Posted on 2006-07-14
5
Medium Priority
?
1,458 Views
Last Modified: 2007-12-19
I've created a chart using Ms Chart Active-X control on Access form and i want to export it to excel sheet along with the datasheet that it creates to excel. So please let me know how do i do it?
0
Comment
Question by:Crystal_De_Souza
3 Comments
 
LVL 58

Accepted Solution

by:
harfang earned 100 total points
ID: 17107153
Hello Crystal_De_Souza,

There is no simple way to do this. Although MS-Chart and Excel use exactly the same charting library, you cannot convert from one to the other. You will have to display the data sheet, copy-and-paste that to Excel, and then recreate the chart there.

If you need to do this often and if you are a really competent VB programmer, you can probably automate some of this, especially as the object model is compatible, but it will be quite a project in itself.

Cheers!
(°v°)
0
 

Author Comment

by:Crystal_De_Souza
ID: 17107282
Thanks harfang !!
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 100 total points
ID: 17209652
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
The best software application must always have an error handling tool
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Wrapper-1-Query. Use an Excel function to calculate a column for an Access query. Part 1. Shows a query in Access that has a calculated column with the results of an Excel worksheet function. See how to call a wrapper function from a query, and …

587 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question