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...
beachcomber, thanks you for the help. I looked at the path you gave me. The rename method was not exactly what I needed, but the Replace method right below it does seem to have some merit. Thank you for the suggestion.
I am trying to edit the linked part to a draft file using VBA. Can anyone help? For example: I have adraft file with part "A" linked to the draft, and I want to chnage the link to part "B" instead.
I am trying to update a 2D draft sheet with data from an excel spread sheet. I can make all of the variables change. But I can't find a working example of how to edit the link between the draft and the part file. For example: If part "A" is linked to the draft, but I want part "B" linked...
