I am trying to automate our weekly "Free Drive Space" chart. Each week, Excel VBA goes out and calculates, and diplays the freespace of various network dirves, in varous tables. A chart is created from the tables, saved as a .jpg and then copied into a chart sheet. The problem is when the program is run the next time, I can not locate the .jpg on the spreadsheet to delete it and replace it with an updated one.
How can I name that picture object so I can locate it on the spreadsheet?
Thanks,
Ken
How can I name that picture object so I can locate it on the spreadsheet?
Thanks,
Ken