Solved

export mschart to excel

Posted on 2006-07-14
5
1,424 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
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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

757 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now