How do i export graphs in Access to excel using VBA code?

[Guest]

Hi,

I want to export a couple of graphs to a single excel file. The graphs are
made in Microsoft Graphs 2000. Can this be done using VBA code. If yes, can
you explian how?

Appreciate your help!

 

[Guest]

Hi,

I want to export a couple of graphs to a single excel file. The graphs are
made in Microsoft Graphs 2000. Can this be done using VBA code. If yes, can
you explian how?

Appreciate your help!

ADDITIONAL INFO:

-The graphs are Microsoft Graph Object.
-Embedded in a Access form as a picture.

 

[mrehandar]

ADDITIONAL INFO:

-The graphs are Microsoft Graph Object.
-Embedded in a Access form as a picture.

CORRECTION:
The graphs are Microsoft Graph Object.
Embedded in a Access SUBFORM.


Plzzzzzzzzzz really need your help

 

[mrehandar]

Private Sub Export_Click()

Dim graphExport As Object

Set graphExport = Me.Ctl3PPContractChart.Object
graphExport.Export "C:\3PP Exported Charts\" & vendor & ".jpg", "JPEG"
Set graphExport = Nothing
Me.Ctl3PPContractChart.Action = acOLEClose

End Sub


I am able to export the graph. But again, there is a problem. After i
click the Export button, the graph in the subfrom gets all re-sized
(i.e. font changes, size changes etc).

Is there a way of preventing that?




PLZZZ HELP...