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. |
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. |
All times are GMT +1. The time now is 05:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com