View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
JohnInStockie JohnInStockie is offline
external usenet poster
 
Posts: 2
Default Exporting chart issue

Hi everyone

I am trying to use the Excel chart.export method to produce an image of a
report from Access.
Access is exporting the report in Snapshot format, and I am then importing
the object as an OLEObject into an Excel Sheet.
I am then using the CopyPicture method on the OLEObject and pasting this
into the chart.
I am then exporting the chart as a GIF.

The problem I am having is that the quality of the gif is very poor so as to
make the whole method useless.

FYI I am not using a pdf writer as the environment I am in prohibits this
method (security gone mad!)

Please help if you can.

John