Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default How to save a bar chart as an image file programmatically?

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.


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default How to save a bar chart as an image file programmatically?

Look at the export method of the chart object.

--
Regards,
Tom Ogilvy


"Fool" wrote in message
...
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.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i save an excel graph as an image file for use on the inter jimwarlick Charts and Charting in Excel 3 July 9th 07 06:05 PM
How to add an image to a worksheet programmatically mjohnson Excel Discussion (Misc queries) 2 March 16th 05 04:48 PM
Export the worksheet background image as an image file - possible? DataFreakFromUtah Excel Programming 2 April 10th 04 04:49 PM
Who can tell me how to programmatically insert an image into Excel by C#? syf Excel Programming 0 January 13th 04 10:29 AM
Save an image from a worksheet to a file barbral Excel Programming 1 August 15th 03 02:39 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"