software

In earlier versions of MS Office/Excel, I have easily extracted as .gif files
charts that I created in Excel worksheets. Either I've simply forgotten how
or something's changed. Anyone help me through this?

does this help?
Sub ExportChartGIF()
ActiveChart.Export Filename:=quot;C:\a\MyChart.gifquot;, _
FilterName:=quot;GIFquot;
End Sub

Sub ExportChartJPG()
ActiveChart.Export Filename:=quot;C:\a\MyChart.jpgquot;, _
FilterName:=quot;jpegquot;
End Sub--
Don Guillett
SalesAid Software

quot;Dick Hannemanquot; lt;Dick gt; wrote in message
...
gt; In earlier versions of MS Office/Excel, I have easily extracted as .gif
gt; files
gt; charts that I created in Excel worksheets. Either I've simply forgotten
gt; how
gt; or something's changed. Anyone help me through this?
This would help if I were a programmer; I'm not. Formerly, my memory is that
when the Excel file saved, it also created a folder into which all graphics
files associated with the .xls file were saved. I simply opened that folder
and moved the .gif file to my website where I wanted the chart.

Is their a solution for a non-programmer?

Thanks for the effort.

Dick Hanneman

quot;Don Guillettquot; wrote:

gt; does this help?
gt; Sub ExportChartGIF()
gt; ActiveChart.Export Filename:=quot;C:\a\MyChart.gifquot;, _
gt; FilterName:=quot;GIFquot;
gt; End Sub
gt;
gt; Sub ExportChartJPG()
gt; ActiveChart.Export Filename:=quot;C:\a\MyChart.jpgquot;, _
gt; FilterName:=quot;jpegquot;
gt; End Sub
gt;
gt;
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Dick Hannemanquot; lt;Dick gt; wrote in message
gt; ...
gt; gt; In earlier versions of MS Office/Excel, I have easily extracted as .gif
gt; gt; files
gt; gt; charts that I created in Excel worksheets. Either I've simply forgotten
gt; gt; how
gt; gt; or something's changed. Anyone help me through this?
gt;
gt;
gt;

I bet you saved the file as .html to get that subfolder with the graphics.

Dick Hanneman wrote:
gt;
gt; This would help if I were a programmer; I'm not. Formerly, my memory is that
gt; when the Excel file saved, it also created a folder into which all graphics
gt; files associated with the .xls file were saved. I simply opened that folder
gt; and moved the .gif file to my website where I wanted the chart.
gt;
gt; Is their a solution for a non-programmer?
gt;
gt; Thanks for the effort.
gt;
gt; Dick Hanneman
gt;
gt; quot;Don Guillettquot; wrote:
gt;
gt; gt; does this help?
gt; gt; Sub ExportChartGIF()
gt; gt; ActiveChart.Export Filename:=quot;C:\a\MyChart.gifquot;, _
gt; gt; FilterName:=quot;GIFquot;
gt; gt; End Sub
gt; gt;
gt; gt; Sub ExportChartJPG()
gt; gt; ActiveChart.Export Filename:=quot;C:\a\MyChart.jpgquot;, _
gt; gt; FilterName:=quot;jpegquot;
gt; gt; End Sub
gt; gt;
gt; gt;
gt; gt; --
gt; gt; Don Guillett
gt; gt; SalesAid Software
gt; gt;
gt; gt; quot;Dick Hannemanquot; lt;Dick gt; wrote in message
gt; gt; ...
gt; gt; gt; In earlier versions of MS Office/Excel, I have easily extracted as .gif
gt; gt; gt; files
gt; gt; gt; charts that I created in Excel worksheets. Either I've simply forgotten
gt; gt; gt; how
gt; gt; gt; or something's changed. Anyone help me through this?
gt; gt;
gt; gt;
gt; gt;

--

Dave Peterson

I just learned this. Hold down the Shift key and click on the Edit menu. You
will get a different menu where you can copy picture, and then paste it.

quot;Dick Hannemanquot; wrote:

gt; In earlier versions of MS Office/Excel, I have easily extracted as .gif files
gt; charts that I created in Excel worksheets. Either I've simply forgotten how
gt; or something's changed. Anyone help me through this?

Perfect. That really isn't what I did before, I don't think, but had exactly
the same result -- thank you VERY much, Dave.

Dick Hanneman

quot;Dave Petersonquot; wrote:

gt; I bet you saved the file as .html to get that subfolder with the graphics.
gt;
gt; Dick Hanneman wrote:
gt; gt;
gt; gt; This would help if I were a programmer; I'm not. Formerly, my memory is that
gt; gt; when the Excel file saved, it also created a folder into which all graphics
gt; gt; files associated with the .xls file were saved. I simply opened that folder
gt; gt; and moved the .gif file to my website where I wanted the chart.
gt; gt;
gt; gt; Is their a solution for a non-programmer?
gt; gt;
gt; gt; Thanks for the effort.
gt; gt;
gt; gt; Dick Hanneman
gt; gt;
gt; gt; quot;Don Guillettquot; wrote:
gt; gt;
gt; gt; gt; does this help?
gt; gt; gt; Sub ExportChartGIF()
gt; gt; gt; ActiveChart.Export Filename:=quot;C:\a\MyChart.gifquot;, _
gt; gt; gt; FilterName:=quot;GIFquot;
gt; gt; gt; End Sub
gt; gt; gt;
gt; gt; gt; Sub ExportChartJPG()
gt; gt; gt; ActiveChart.Export Filename:=quot;C:\a\MyChart.jpgquot;, _
gt; gt; gt; FilterName:=quot;jpegquot;
gt; gt; gt; End Sub
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt; Don Guillett
gt; gt; gt; SalesAid Software
gt; gt; gt;
gt; gt; gt; quot;Dick Hannemanquot; lt;Dick gt; wrote in message
gt; gt; gt; ...
gt; gt; gt; gt; In earlier versions of MS Office/Excel, I have easily extracted as .gif
gt; gt; gt; gt; files
gt; gt; gt; gt; charts that I created in Excel worksheets. Either I've simply forgotten
gt; gt; gt; gt; how
gt; gt; gt; gt; or something's changed. Anyone help me through this?
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Hi Dick,

Another way is to select the chart and copy it with ctrl c then open any
image processing software you have and paste into that. You can then save as
whatever image type you wish bitmap, jpeg, gif, tiff etc. The standard
microsoft Paint will do just fine.

HTH
Martin
Thanks, Martin. I'll try that. I thought I had tried that, right-clicking
on the chart, but it didn't seem to offer the option to copy. But I'll try
it again. The earlier response solved my problem and the project is
complete, but it is a recurring need.

Appreciate your thoughtfulness.

Dick

quot;MartinWquot; wrote:

gt; Hi Dick,
gt;
gt; Another way is to select the chart and copy it with ctrl c then open any
gt; image processing software you have and paste into that. You can then save as
gt; whatever image type you wish bitmap, jpeg, gif, tiff etc. The standard
gt; microsoft Paint will do just fine.
gt;
gt; HTH
gt; Martin
gt;
gt;
gt;