VB and VBA Users Source Code: Re: Exporting an Excel Chart to a gif image file

VB/VBA Source Code
Re: Exporting an Excel Chart to a gif image file

By:	Michael
Email (spam proof):	Email the originator of this post
Date:	Sunday, September 21, 2003
Hits:	1340
Category:	Office

Article:
I used this code to export my charts and then to import them into powerpoint. Unfortunately Office 97 has no direct command equivalent in VBA to the Copy-PasteSpecial as Picture-Command. If you use only the Paste command in VBA all the data of the excel-file will be pasted too and therefore the powerpoint files become very large. But no matter what picture-filter I use (gif, jpeg, png), my resolution is always worse than if I would copy it manually and paste it as a picture into powerpoint. Does anyone know, how office 97 is handling this internally or what I need to do to acheive a higher resolution?
Terms and Conditions
Support this site Download a trial version of the Excel Workbook Rebuilder