Hi,

I have seen several posts on this topic but unable to choose one because each of the scenarios is unique. Let me explain my scenario.

We have several old drawings and each drawing may have several sheets. I open one of the old drawings and would like to replace the existing sheet format with another one that is present in one of the shared server locations. So the macro should give me an opportunity to choose a new format from the shared server location and replace the existing format. Any pointers to this question is appreciated.

thanks

Ananth