Thread: CopyPicture
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Remi Remi is offline
external usenet poster
 
Posts: 4
Default CopyPicture

Thank for your cooperation,
Changing screen resolution, or zomming excel view, change
nothing.
For your comprehension, I want to show complex processus
drawn in excel into a web way. An other way will be to
save the Excel sheet in an HTML format.
But : there is no way to resize the destination

Remi
-----Original Message-----
Hi Remi

I think it's a limitation of a "maximum screen resolution

in Windows" kind -
can't find it documented anywhere though. Perhaps setting

a window zoom in
Excel might help to get more and smaller cells into it.

It might also prompt
"out of memory" and die. Zoom does that at times. But

who'd need a picture
bigger than maximum screen resolution ?

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Remi" skrev i melding
...
Thank you for the tip "SHIFT key".

"Copy Picture" do the same as my macro:
ActiveSheet.Cells.CopyPicture [xlScreen/xlPrinter],
[xlPicture/xlBitmap]
But now I can see a message :
"this image is too large and will be truncated"
(translated from french with www.google.com)

It seem to be no way for a large selection of cells,

and I
will have to concatenate several little pictures
acceptable from Excel to have the expected one !?



.