Change source path in PPT link from Excel

[ggauravs]

Hi All,

This is my frrst post in this forum.

I have created a PPT which is linked with my excel data and charts. Now I have to copy it at different location (Both PPT and excel), But due to change in path; my PPT is not updating with latest data points and charts. I know, I can change link using edit link.
My PPT is having around 50+ link. Can any one help me with some <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> code which can help me to replace old path using the current path.

any suggestion would be helpful.

Thanks!
Gaurav

 

[VoG]

Duplicate of http://www.mrexcel.com/forum/genera...744902-change-source-path-ppt-link-excel.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule #9 here: Forum Rules).