Community Tip - Did you get an answer that solved your problem? Please mark it as an Accepted Solution so others with the same problem can find the answer easily. 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).