Best method of attack

[Anonymous]

I have an assembly as a template that was created by a previous employee.  There are known variables that are controlled with an Excel spreadsheet.

What I am attempting to do is create a VB form that the user can input the known variables and then have the program open the template, perform the changes, and copy to the vault. Sounds easy enough. A few caveats:

1. If I store the template in the Vault (preferred), how do I perfrom a "Copy Design" with a VB6 program?
2. If I store it on a hidden network drive, this prevents users from screwing it up, but then I have to open each indivual file and perform a "SaveAs". Also easy enough. But, since the previous employee linked each component of the assembly to the Excel file, I would need to perform a "Change Source" to the newly created Excel spreadsheet in each component. Not sure how that is done.
3. What's the best method that anyone has performed a similar scenario? I do have VB2010 Express, but just not as comfortable with it as VB6. (I know, get with the current .Net)

Any suggestions/comments appreciated!

[Anonymous]

Well, here's my work-around:

Open the Excel file and perform a Save-As into new directory based on user input for a part number.

Open Draft and Assembly - SaveAs aforementioned part number.

Open each component, delete and replace Excel spreadsheet. The problem here is that unless I open and close the new Excel spreadsheet, no type of Component.Update will work.

Save all components. Update Assembly. Update Draft.

Clumsy, perhpas, but works as intended and will take what would normally be 30 minutes and reduces it to two.