Hi Don. When I tried your macro I got the following error:
Run-Time error '91':
Object variable or With block variable not set.
I'm afraid I don't have clue what that means, being VBA illiterate.
Oh, by the way, thanks for all your help in the many other posts.
--
Sincerely, Michael Colvin


"Don Guillett" wrote:

This is an excel macro. copy/paste into a regular excel macro moduleassign
to a buttonchange to suit the path desiredselect the chart desired and
execute the macro

--
Don Guillett
SalesAid Software

"SARANJAI" wrote in message
...
Thanks for your advice. But honestly, I don't know what you mean...:-(

"Don Guillett" wrote:

try this.
Sub ExportChartJPG()
ActiveChart.Export Filename:="C:\a\MyChart.jpg", _
FilterName:="jpeg"
End Sub


--
Don Guillett
SalesAid Software

"SARANJAI" wrote in message
...
Tried to extract a picture from an Excel worksheet and save it as a
*.jpg
/
*.gif / *.bmp file - don't know how to do. Anyone knows how to do
that?
Same
goes for Word.