How to save a bar chart as an image file programmatically?

F

Fool

Hello, I am designing a Excel worksheet.
It contains a bar chart. I run VBA to get data from a database and update
it's data.
Then I want to save the bar chart as an image, such as jpeg file.
Would you please tell me how to save a bar chart as an image file by VBA?

Thanks in advance.
 
T

Tushar Mehta

Check the chart object's Export method.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Move Chart with Text 0
Images are pixelated when saving to PDF 0
Scroll does not show preview 0
Merging from an Excel file with graphics 1
Embed the same Excel multiple times 0
Bar Chart with Data Elements 1
Excel file won't save to iCloud on Mac 0
Modify the gantt chart view in project center (WPA) (MS Project 2010) 0

Top