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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Rehan said:
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!
Click to expand...

ADDITIONAL INFO:

-The graphs are Microsoft Graph Object.
-Embedded in a Access form as a picture.
 
Rehan said:
ADDITIONAL INFO:

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

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


Plzzzzzzzzzz really need your help :)
 
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...
 
Back
Top