find a specific chart in Excel from other applications
 

Hi everybody,
I use a lot of Excel charts in power point, for both security and file size
reasons I prefer to paste as picture instead of live objects, but the
updating is difficult, so I wrote some code to paste the chart as linked
object then save the path and break the link , this trick helped me to have
the path and possibily add some code to find the exact object in Excel and
paste it into my PP whenever I need an update
here is an example for the path generated by .SourceFullName
C:\WINDOWS\Standard\Desktop\Book999-test.xlsx!Sheet1![Book999-test.xlsx]Sheet1 Chart 1

I know how to open an Excel file from other aplications but I dont know how
to access and copy the exact object referenced by the above path , any
suggestions?
--
Best regards,
Edward