VBA code to duplicate a page and all the shape sheet references

Started by jebuxx, January 26, 2015, 06:45:37 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

jebuxx

Looking for a VBA code that will allow a page to be duplicated to another all while keeping the shape sheet formulas. 
I have a dynamic graphics template on one page that is adjustable via imputes from a data page. When I copy the template and paste to a new page
all the shape sheet formulas and relationships are gone. The formulas are still there in the shape sheet but all the references to that data page are gone.
Trying to prevent having to copy all the shape sheet formulas for the original page to the duplicated page. This would take far too long.
thoughts?


jik_ff

Not sure about relationships, but I have used the visio Selection object copy then paste method to paste shapes to a new page (copying over template objects to a new page), and the formulas seem to carry over.