Thanks for the info. Do you have any examples of your use of replace? I am more of a compiler than a programmer. I am createing a rules based configurator in Excel, using VBA as my programming language. I have my rules laid out in "if..hen..else" comments. It pulls data from SQL data base to populate dimensions. It works pretty well. I am able to change the variables and part properties. But, I have not found a good example of changing or replacing the linked part to a draft file. How can I get in touch with you?