Community Tip - Did you get called away in the middle of writing a post? Don't worry you can find your unfinished post later in the Drafts section of your profile page. X
I have a series of about 40 Mathcad files that I must open, calculate, and save in sequence to obtain a final result. Any change in file inputs for one worksheet in the series, results in having to run the series of files forward again to obtain the new final result. Is it possible to create a master Mathcad worksheet that will automate the task of opening, calculating, and saving the worksheets in sequence, so I will not have to do this in a manual manner?
Solved! Go to Solution.
@MW_5360621 wrote:
I have a series of about 40 Mathcad files that I must open, calculate, and save in sequence to obtain a final result. Any change in file inputs for one worksheet in the series, results in having to run the series of files forward again to obtain the new final result. Is it possible to create a master Mathcad worksheet that will automate the task of opening, calculating, and saving the worksheets in sequence, so I will not have to do this in a manual manner?
Hi,
I guess you can automate update procedure using AutoIT or AutoHotKey application (if you have some programming knowledge).
Maybe including/referencing worksheets from within one master sheet could help:
@MW_5360621 wrote:
I have a series of about 40 Mathcad files that I must open, calculate, and save in sequence to obtain a final result. Any change in file inputs for one worksheet in the series, results in having to run the series of files forward again to obtain the new final result. Is it possible to create a master Mathcad worksheet that will automate the task of opening, calculating, and saving the worksheets in sequence, so I will not have to do this in a manual manner?
Hi,
I guess you can automate update procedure using AutoIT or AutoHotKey application (if you have some programming knowledge).