Can I get a chart to an image file?
 

My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?

Can I get a chart to an image file?
 

Look the export method of the Chart object.

--
Regards,
Tom Ogilvy

"Lynda" wrote in message
...
My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?

Can I get a chart to an image file?
 

Thanks Tom how would I do that in Visual basic code I
have never used it before.

All I need is a button. I can get that from the form
toolbar but I dont know how to find export on the menu.

-----Original Message-----
Look the export method of the Chart object.

--
Regards,
Tom Ogilvy

"Lynda" wrote in
message
...
My excel speadsheet at work has 2 charts on it and I
need
to send them out to my colleagues does anyone know any
vb
to have a button which will create 2 files on my
desktop
which are images containing the two charts?




.

Can I get a chart to an image file?
 

Might want to fix your clock.

January 6th ??

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
try one of these
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub

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


--
Don Guillett
SalesAid Software

"Lynda" wrote in message
...
My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?

Can I get a chart to an image file?
 

There is no export menu I don't believe. I said Export METHOD. Anyway, see

Don Guillet's post .

He provided sample code.

--
Regards,
Tom Ogilvy

"lynda" wrote in message
...
Thanks Tom how would I do that in Visual basic code I
have never used it before.

All I need is a button. I can get that from the form
toolbar but I dont know how to find export on the menu.

-----Original Message-----
Look the export method of the Chart object.

--
Regards,
Tom Ogilvy

"Lynda" wrote in
message
...
My excel speadsheet at work has 2 charts on it and I
need
to send them out to my colleagues does anyone know any
vb
to have a button which will create 2 files on my
desktop
which are images containing the two charts?




.

Can I get a chart to an image file?
 

fixed

--
Don Guillett
SalesAid Software

"Tom Ogilvy" wrote in message
...
Might want to fix your clock.

January 6th ??

--
Regards,
Tom Ogilvy

"Don Guillett" wrote in message
...
try one of these
Sub ExportChartGIF()
ActiveChart.Export Filename:="C:\a\MyChart.gif", _
FilterName:="GIF"
End Sub

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


--
Don Guillett
SalesAid Software

"Lynda" wrote in message
...
My excel speadsheet at work has 2 charts on it and I need
to send them out to my colleagues does anyone know any vb
to have a button which will create 2 files on my desktop
which are images containing the two charts?