Solved

export mschart to excel

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

679 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