Export Chart to Word


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.
 
Ad

Advertisements

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top