J
JohnInStockie
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
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