Naming a Picture Element

pulkoks · Apr 8th, 2002, 04:28 PM

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

Jack in the UK · Apr 8th, 2002, 04:48 PM

Hi

can i ask you post the codeso we can see and sugget a way, always best way

hope this is ok....

Apr 8th, 2002, 04:48 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi can i ask you post the codeso we can see and sugget a way, always best way hope this is ok.... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 8th, 2002, 04:28 PM	#1
pulkoks New Member Join Date: Apr 2002 Location: KenP Posts: 1	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