Having inserted a picture into an Excel worksheet, I am having trouble copying the picture to another worksheet or workbook since I am unsure what name the picture has, since there could be a number of different pictures on the original sheet. Any ideas how i could do this. Basically i am setting up a database which has picture ID on the page.
Good question, I need to get a bigger brain! I tried your routine which was great. I have set up a template worksheet, which I retrieve data for, then copy the data to another workbook for storage. I will only have 1 picture on the page, however, having run your routine i see that buttons i have generated are shown as well. Is there any way of getting the name of the only picture on a sheet. thanks for your time.
Sorry, i thought of one final question. If you put in some pictures and then delete them, the picture number keeps on going up. Is there any way of reseting the numbers down to the only pictures on the page.