topic Re: How to define variables in Mathcad using API via Excel 2010 in Mathcad

How to define variables in Mathcad using API via Excel 2010

ptc-5200262 — Thu, 03 May 2018 17:03:20 GMT

Hi All,I was hoping someone might be able to help. I'm using Mathcad 14 to perform calculation cases. I could easily have 50 sets of case in either Excel or Matlab and need to generate 50 corresponding worked through cases. Ideally I would like to generate each case file as a

Re: How to define variables in Mathcad using API via Excel 2010

RichardJ — Mon, 12 Aug 2013 17:36:39 GMT

When you use SetValue (based on your description, I assume this is what youe are using to set the value in the worksheet) the variable is bound before any binding that is in the worksheet. So if you set a value of 3 for b, and then have a definition b:=3 in the worksheet, the variable binding from the API is prior to the worksheet definition, and is therefore overwritten by it. You cannot change a worksheet assignment using SetValue. If you really want to change a variable definition in the worksheet then you need to edit the XML of the region. The attached worksheet shows how to do this using a vbscript (which should be easy enough to port to VBA).

Re: How to define variables in Mathcad using API via Excel 2010

ptc-5200262 — Tue, 13 Aug 2013 14:31:26 GMT

Many thanks for this; much appreciated. Unfortunately I'm not much of a programmer and would appreciate it if anyone has a VBA version of the script.

Re: How to define variables in Mathcad using API via Excel 2010

tpenshorn — Mon, 06 Jan 2014 17:26:36 GMT

How did you set up your file? I'm trying to do something similar at the moment only I have absolutely no idea where to start. I can't even get mathcad to open in the VBA script.

My ultimate goal is rather simple I think, I just want a macro to open mathcad from excel and copy values from excel into the mathcad document and then save the mathcad file.

Re: How to define variables in Mathcad using API via Excel 2010

AndyWesterman — Wed, 08 Jan 2014 11:20:48 GMT

Hi,

opening Mathcad from Excel isn't too difficult.

The Help files aren't too descriptive but at least it does seem to work.

Copying the values into the sheet however is a little more difficult.

Using SetValue will force the value change but in a temporary way, it isn't saved in the XML code.

You can use the regions function to access the XML code & it can be changed (as in the attached).

The downside is that mathcad doesn't know that there has been a change so you will need to explicitly save the document.

My quick code is messy & the file name needs to be created properly.

The other issue stems from how you code the XML to write.

I have taken code to assign a value to a variable & copied it into a string. to do more than this will be very complex.

Each tag in the property field must be unique but there should be no limit to the number permitted

regards

Andy