Scripts in Mathcad

[ptc-2620282]

Hi, I would like to open a second sheet in mathcad using a script into a button I searched in help : it presents an "Open" method but I don't understand how it works. Can you help me? Thanks

[RichardJ]

See the attached example. Richard

[ptc-2620282]

Thanks But in fact, I would like to do more things with this new sheet : In the new sheet opened, I would like to - set a variable named "var" to 1 - Save the new sheet - close the new sheet In Help/Developer's Reference, it is written : objMC.SetValue(Name As String, Value As Variant) What is "objMC"? I suppose it corresponds to the new sheet opened but the opening of the new sheet is not sent to a variable. Can you help me please?

[RichardJ]

"Yann Rouault" wrote:

But in fact, I would like to do more things with this new sheet : In the new sheet opened, I would like to - set a variable named "var" to 1 - Save the new sheet - close the new sheet

[ptc-2620282]

I have a model composed of 6 mathcad sheets in "cascade". I explain : -The first one, contains a form with text areas and list boxes in which the user enters the inputs. -Each sheet gives a result -Each sheet except the first one, makes reference to the previous sheet to recover the results and make other calculations Now, I would like to run my model in automatic with a program (a button in a new sheet in Mathcad for example) which, for each turn a the loop : -send the inputs in place of the user (differents for each turn of loop) -run all the sheets -return the final result (of the last mathcad sheet) and write it in a Excel sheet

anonymous wrote:

Why? When you save the sheet the value assigned to "var" will not be saved.

[RichardJ]

You would be much better off rewriting the final sheet (i.e. the one that references all the others) to make the final answer a function of the parameters you wish to change, and then just calling the function in a loop. It's possible to do what you suggest, but it's probably going to be more work than rewriting the final sheet. Richard