export chart as jpg
 

With the j-walk charting tool I can for example export a chart in jp
format - but can this operation be done by a macro? if so how

--
hk
-----------------------------------------------------------------------
hke's Profile: http://www.excelforum.com/member.php...nfo&userid=155
View this thread: http://www.excelforum.com/showthread.php?threadid=26755

export chart as jpg
 

You can use code similar to the following:

ActiveChart.Export Filename:="C:\Data\Chartpic.jpg", _
FilterName:="jpeg"


hke wrote:
With the j-walk charting tool I can for example export a chart in jpg
format - but can this operation be done by a macro? if so how?




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

export chart as jpg
 

May I suggest you use GIF instead of JPG? GIFs are much better suited to line
drawings such as charts, with relatively few distinct colors, often covering large
areas. JPGs are better for photographic artwork, with continuously varying colors
across the image.

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

Debra Dalgleish wrote:

You can use code similar to the following:

ActiveChart.Export Filename:="C:\Data\Chartpic.jpg", _
FilterName:="jpeg"


hke wrote:

With the j-walk charting tool I can for example export a chart in jpg
format - but can this operation be done by a macro? if so how?