excel export macro - resolution issues?

[#1]

Hi everyone,

I have created a macro where i export a number of objects as images to an excel document.  This works fine but the image clarity is not what i would like it to be.  is there a way to improve the reosolution of these images?  i know we can export the underlying data but that is not what is required.

I am using the copybitmaptoclipboard function, is there any other option?

Thanks in advance

[paola_valenti]

I have exactly the same problem: if I copy with macro using ".CopyBitmapToClipboard", image is grainy!

Have you ever find any solution?

[m_woolf]

https://community.qlik.com/docs/DOC-8966#comment-39627

[Frank_Hartmann]

instead of using Shapes.Paste method try using Shapes.PasteSpecial(1)

hope this helps

[paola_valenti]

It works wonderfully!!

Could you please explain in few words the difference between Paste and PasteSpecial and the meaning of (1) parameter?

[Frank_Hartmann]

.Shapes.PasteSpecial(DataType)

0 - Default

1 - Bitmap

2 - Enhanced Metafile

3 - Metafile Picture

4 - GIF

5 - JPG

6 - PNG

7 - Paste Text

8 - HTML

9 - RTF

10 - OLE Object

11 - Paste Shape

hope this helps!

[paola_valenti]

Yes, it helps a lot! Thanks