Image of chart created after publishing sheet

[martin_j_king]

Hi,

Having a mjor issue with an excel workbook. I have a sheet with a table of sales data and a graph.
This sheet is to be autopublished to a webpage everytime the document is saved. this bit works great, saves the page and accessible on the network

Problem is, Excel imbeds a bitmap of the chart, over the top of the chart, named Picture X eveytime, sometimes at random, and numerous times. after a couple of days there can be hundreds of pictures and you can't open the file; it hits over 1m kb of memory trying to render all these images.

Has anyone come across this before; I'm a complete novice to auto publish feature so maybe the simplest setting somewhere like creat image of chart

Any help would be great

thanks

 

[t.powley]

As long as the image file name does not change you could use this macro to delete the image every time the workbook is closed.

open the VB Editor - ThisWorkbook object - view code

add following the code:

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Kill "C:\location\image.bmp"
End Sub

Cange location and image.bmp to the location and file you wish to remove.

Save the workbook before testing the macro

 

[martin_j_king]

unfortunately its name changes, normally picture X in sequential order or just chart x.
I have a macro that deletes all items but unfortunately deletes the chart;

Sub DeletePics()
Sheets("4.Wiki").Select
ActiveSheet.Shapes.SelectAll
Selection.Delete
End Sub

Any ideas how I can select pictures only and not charts? or Cut the chart and paste to another sheet, then I could delete all images, then paste this chart back

actually, I'm going to try that now, should be ok with that code

thanks for the suggestion of the workbook close though