Exporting MS Access Charts to Word/Excel

views:

1025

answers:

+2 Q:

Exporting MS Access Charts to Word/Excel

I am amazed and dumbfounded to find out that a report generated in Microsoft Access will not include the charts I generated when exporting to Excel, Word or any other technology.

Has anyone found a work-around for this? My user base needs to be able to copy/paste the generated reports (including graphics) into different status reports. Copying/pasting does not seem to be possible directly from the Access report.

+1 A:

I would really need more info to help you (which version of Access, How are you generating the graph, etc.).

Have you tried the "Publish It to Microsoft Word" or "Analyze it with Microsoft Excel" options from Print Preview?

One option your users have is to Alt-PrintScreen and paste it.

What I typically do is have users install CutePDF Writer (it's free), and it lets them print to a PDF, which they then can send to whomever they want.

bruceatk 2009-01-29 04:07:44

I am using Access 2003. The graph lies in a group header. Its source is a query. The graph therefore gets printed once for every group of data.All of the in-house publishing utilities that you mention export the data perfectly (rows of text, essentially) but completely ignore charts.

cLFlaVA 2009-01-30 02:35:49

I am familiar with CutePDF and obviously with the PrintScreen/crop options, but I wanted to explore more elegant VBA solutions if at all possible.Thanks for your help.

cLFlaVA 2009-01-30 02:36:31

There is also something called snapshot, that can be further viewed by users and/or inserted in documents.

Philippe Grondier 2009-01-29 05:33:22

install CutePDF Writer (it's free), and it lets them print to a PDF

2009-05-12 08:43:14

ansaurus

tags:

views:

answers:

Exporting MS Access Charts to Word/Excel

related questions