1. In general, jpg is the wrong format to use for exporting charts. Use gif
or png instead.

2. I ran your code several times and the output files were all identical.
What else is happening to the chart in between export cycles?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Jared" wrote in message
...
Hi, I have a chart object in an excel sheet, that I have programmatically
exporting the chart to JPG file. I have a button the the page, that I
have
tied to VB MOD in the worksheet that does this:

Dim chartObject As chartObject
Set chartObject = Sheet3.ChartObjects(2)
chartObject.Chart.Export GetFilePath(), "jpg", False
Set chartObject = Nothing

The export works fine and creates new images every time the user clicks on
the button, but the problem is user is exporting the chart many times the
chart image file starts to shrink in size? I am using Excel 2003. Has
anyone out there had this problem, and if so what did they do to correct
the
issue?

Thanks