Skip to main content
M
MW_53606216-Contributor
6-Contributor
July 30, 2022
Solved

Using a Mathcad Worksheet to Open, Calculate, and Save a Series of Mathcad Worksheets

  • July 30, 2022
  • 2 replies
  • 1192 views

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?

Best answer by MartinHanak
@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).

2 replies

W
Werner_E25-Diamond I
25-Diamond I
July 30, 2022

Maybe including/referencing worksheets from within one master sheet could help:

https://support.ptc.com/help/mathcad/r8.0/en/index.html#page/PTC_Mathcad_Help/to_reference_worksheets.html

M
MartinHanak24-Ruby IIIAnswer
24-Ruby III
July 31, 2022
@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).

    Terms & ConditionsAccessibility statement