Secret Chimpanzee
Board Regular
- Joined
- Jun 21, 2012
- Messages
- 141
Hi there,
I have a Powerpoint pack that contains linked charts and data tables from more than one Excel source. New iterations of the Excel sources are usually saved down each month and the links in the PPT pack need to be changed accordingly.
I need some code that will change the link sources by looping through 2 excel columns to find the old file path (column D) and the new file path (column E).
Thanks in advance
I have a Powerpoint pack that contains linked charts and data tables from more than one Excel source. New iterations of the Excel sources are usually saved down each month and the links in the PPT pack need to be changed accordingly.
I need some code that will change the link sources by looping through 2 excel columns to find the old file path (column D) and the new file path (column E).
Thanks in advance