Celtih
12-03-2015, 04:30 AM
Hey all
Do anyone know how to solve the following problem. I am not very experienced in VBA coding, so i will try to explain it as simple as I can.
Problem:
I have a template of a PowerPoint (X) that links to a template of a Excel file (A). The links are to charts/graphs.
When I copy X to a new PowerPoint (Y) and copy A to a new Excel file (B), I want to update the links from Y (that's still linking to A) to B.
The excel files and PowerPoint files are located in different folders.
Excel files: X:\Customer\2015\Graph (A.xlsx) and (B.xlsx)
PowerPoint: X:\Customer\2015\Reports (X.pptx) and (Y.pptx)
It is about 300 links and I am going to do it more than once, so it would be terrible if I had to do i manually.
I hope someone can help :)
Do anyone know how to solve the following problem. I am not very experienced in VBA coding, so i will try to explain it as simple as I can.
Problem:
I have a template of a PowerPoint (X) that links to a template of a Excel file (A). The links are to charts/graphs.
When I copy X to a new PowerPoint (Y) and copy A to a new Excel file (B), I want to update the links from Y (that's still linking to A) to B.
The excel files and PowerPoint files are located in different folders.
Excel files: X:\Customer\2015\Graph (A.xlsx) and (B.xlsx)
PowerPoint: X:\Customer\2015\Reports (X.pptx) and (Y.pptx)
It is about 300 links and I am going to do it more than once, so it would be terrible if I had to do i manually.
I hope someone can help :)