How can I export a chart from Excel to Access??

[Guest]

Hello
How can I export an excel chart to Access??

Thanks a lot

 

[sjoo.kwak]

hi Kyriaki

Excel chart can be exported as a image file(GIF or JPG format)
I can't understand what you asked

following is an example:
----------------------------------------------------------------------------
Sub Create_GIF()
Dim mychart As Chart
Set mychart = ActiveSheet.ChartObjects(1).Chart
mychart.Export FileName:="c:\Mychart.gif", FilterName:="GIF"
End Sub
----------------------------------------------------------------------------

 

[Guest]

I want to export an excel chart to Microsoft Access. I ask if I can export
the excel Chart to Microsoft Access in a table or in a form. Is there any
possibility?

 

[sjoo.kwak]

if field data type is OLE object, the field restore binary data.
an exported chart image file can restored the field.
If you want to display a chart on the access form,
you'd better use active-x chart control(eg,Microsoft Chart Control or
the third party controls)