E
Edward
Hi everyone,
After we break a linked object like a chart from excel in PP, can we relink
it again using VBA?
I'm trying to write a code to insert a chart or a range from Excel in PP
save the path ( using linksource ) , converting the object to EMF and attach
the sourcefile path as a tag to the picture.
when a user clikcs on update program will remove the picture go and find the
same object and paste it again and convert it to a picture.
every step seems to be easy and straight forward , but I don't know how to
establish a new link in VBA if I have the path something like
C:\WINDOWS\Standard\Desktop\Book10.xlsx!Sheet1![Book10.xlsx]Sheet1 myChart
I don't have to use links , but it seems that's the easiest way to refrence
a chart or a range in Excel ?
any suggestions ?
After we break a linked object like a chart from excel in PP, can we relink
it again using VBA?
I'm trying to write a code to insert a chart or a range from Excel in PP
save the path ( using linksource ) , converting the object to EMF and attach
the sourcefile path as a tag to the picture.
when a user clikcs on update program will remove the picture go and find the
same object and paste it again and convert it to a picture.
every step seems to be easy and straight forward , but I don't know how to
establish a new link in VBA if I have the path something like
C:\WINDOWS\Standard\Desktop\Book10.xlsx!Sheet1![Book10.xlsx]Sheet1 myChart
I don't have to use links , but it seems that's the easiest way to refrence
a chart or a range in Excel ?
any suggestions ?