VB and VBA Users Source Code: Re: Re: Exporting an Excel Chart to a gif image file
[
Home
|
Contents
|
Search
|
Reply
|
Previous
| Next ]
VB/VBA Source Code
Re: Re: Exporting an Excel Chart to a gif image file
By:
Robert Kesztler
Email (spam proof):
Email the originator of this post
Date:
Monday, October 13, 2003
Hits:
2379
Category:
Office
Article:
Here is the GIF export code: (I used this in a form) If you need I can send to you the sample file) Private Sub UserForm_Initialize() Worksheets("Sheet1").ChartObjects(1) _ .Chart.Export _ Filename:="c:\temp_picture.gif", FilterName:="GIF" Application.DefaultWebOptions.LoadPictures = True Image1.Picture = LoadPicture("c:\temp_picture.gif") end Sub With this Sub I export the Chart to file, and the Import it into the Form as a Picture You have to create one chart on the Excel sheet and one Picture on the Form. Best Regards, Robert
Terms and Conditions
Support this site
Download a trial version of the Excel Workbook Rebuilder
