Community Tip - You can change your system assigned username to something more personal in your community settings. 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).