Exporting charts in Access2000

J

Jeff

Stephen,

I appreciate your insight. I accessed your report
utilities, and made some progress. However, I am using
2000 and the following VBA produces a "User-defined type
not defined" error in debug mode.

Dim pf As clsPrintToFit

Any suggestions.
-----Original Message-----
Use the ReportUtilities on my site to export the Report as a series of
EMF files, one for each page of the Report. EMF's can be directly loaded
onto PP slides and are fully scaleable, resolution inependant.
http://www.lebans.com/ReportUtilities.htm

Please note, if you just want the Graph off of each page of the report
then the CHart object has an Export method. Here is a post from SteveT
on this subject. THe example code is for a Form but you can adapt it for
your report

From: SteveT (SteveT)
Subject: Re: export chart


View this article only
Newsgroups: microsoft.public.access.forms
Date: 2002-09-19 15:24:04 PST


Create two command buttons and paste the code below into the click
events.
Paste the ExportRs function in the same module and note the code to go
into
the Form Error event.

Steve

To save image:

Private Sub cmdSaveChart_Click()
'use this to export as a jpg, "gif" also works
Dim ochart As Object

Set ochart = Me.Graph1.Object

oChart.Export "c:\temp\MyChart.jpg", "jpeg"
oChart.Application.Quit

Set ochart = Nothing
End Sub




--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.




.
..
 

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