View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] john.opie@gmail.com is offline
external usenet poster
 
Posts: 7
Default Picture Too Big and Will Be Cut?

Hi Mike -

Thanks for the reply.

The problem with As Shown On Screen is resolution and artifacts. For
instance, the original is shown on screen in page-break preview, and
copying As Shown On Screen shows then the border of the page-break
preview, i.e. an artifact from the screen comes over with the picture.
On the target sheet the picture of the table is then surrounded by a
blue line that has to be removed by hand. As Printed avoids this
problem entirely and increases the resolution to 1200 dpi, up from the
72 or so from "As Shown On Screen". Makes the picture bigger, but in
this day of multiple hundred GB drives for the price of a good lunch in
Manhatten, not really a consideration any more.

I've resolved the problem by resizing the tables in question, but it is
for us rather odd, since we've been doing this via VBA code for quite a
while without any trouble. This time I'm doing it by hand to work on a
prototype report, and it's the first time I'd ever seen that sort of
message...

Thanks!

John