Solved

export mschart to excel

Posted on 2006-07-14
5
1,447 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
5 Comments
 
LVL 58

Accepted Solution

by:
harfang earned 25 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 25 total points
ID: 17209652
0

Featured Post

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

626 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