Hi,
I am trying to write a macro that will take a set of excel charts and then copy them as pictures into another spreadsheet. The graphs will be updated every month and the most recent version should replace the old version. The problem is that pictures seem to be numbered dynamically in Excel. For example if you cut and then paste back a picture it will have a different number than before eg Picture 339 will become Picture 341 when pasted back. My macro fails because when it tries to delete the old picture it fails to find it and I end up with one picture on top of another. I have tried using the Shapes collection to no avail, the same thing happens.
I am trying to write a macro that will take a set of excel charts and then copy them as pictures into another spreadsheet. The graphs will be updated every month and the most recent version should replace the old version. The problem is that pictures seem to be numbered dynamically in Excel. For example if you cut and then paste back a picture it will have a different number than before eg Picture 339 will become Picture 341 when pasted back. My macro fails because when it tries to delete the old picture it fails to find it and I end up with one picture on top of another. I have tried using the Shapes collection to no avail, the same thing happens.