Export Chart to Word

  • Thread starter Thread starter michaelc
  • Start date Start date
M

michaelc

I have a bar chart that I built in Access. When I export
the report to Word, the chart does not export. Any
thoughts? Thanks.
 
Access won't export graphics as you'd expect.

If it's the chart you want, build it on a form and use this code to export
the chart/graph to a JPEG or GIF:

Private Sub cmdExport_Click()

Dim strFile As String
strFile = InputBox("Please Enter a valid path and file name (ie:
c:\temp\graph.jpg)", "Save As?", "c:\temp\graph.jpg")

Dim gObj As Object
'the graph in this example is named "Graph1"
Set gObj = Me.Graph1.Object
gObj.Export strFile, "JPEG" ' "GIF" also available
Set gObj = Nothing
Me.Graph1.Action = acOLEClose
End Sub

Steve
 
Back
Top