If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
VBA,link
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 ? -- Best regards, Edward |
Thread Tools | |
Display Modes | |
|
|