export EXCEL-charts programmatically in 'Picture'- format
Posted on 2009-07-02
I know the options to export a chart via VBA in GIF or JPG - but the quality of this often is not as good as when choosing [shift]+ - [copy picture] - appearance/size =as shown on screen and pasting it.
I'm wondering if there is a way to export the chart into the same format (i guess it is wmf or emf) that EXCEL uses internally for the above described copy-paste mechanism
I was already looking wild around for hours but I didn't find a proper solution so far - I presume I have to go over the clipboard object with API-calls etc. - that's beyond my semi-professional/amateur status
Thanks for a good working proposal