Programmatically create variable names and assign values from Excel spreadsheet (MCD15)?

As far as I'm aware, Tom, there is no way of programmatically creating names in a straightforward fashion. 

I've asked for such a feature several times over the years, but it's not appeared yet.  There have been other user requests for this feature, eg.

https://community.ptc.com/t5/PTC-Mathcad/Create-variable-names-automatically/m-p/574404

Coincidentally, I recently (Apr 2020) followed up an Alfasoft article on Unicode character creation by asking Alfasoft about this capability.   They said that they had had similar requests from other customers, didn't know whether it was on PTC's development path for Mathcad, but would forward my request to PTC.

https://support.alfasoft.com/hc/en-us/articles/360003722078-How-to-add-things-on-top-of-characters-used-as-variable-names

With a createName type function, it would be straightforward to vectorize it over a list of names imported from Excel.

Stuart

From my letter to Alfasoft:

Thank you for posting the referenced article - it was interesting and solves a particular problem that several have had over the years. However (there’s always a ‘however’, isn’t there?), the process of adding a constructed character or name by copy & paste is somewhat mandraulic, not to mention “copy&paste” errors being a somewhat notorious and common phenomenon. On the face of it, the process would seem to be better suited to automation.

Could a feature request please be raised to add a function to Mathcad Prime 6 that takes a string and creates a new name (variable/function) on the left-hand side of a definition and which is then available for use 'later on' in the worksheet?

Eg, make a name ...

newName:=concat("var",num2str(1))
newName = "var1"

or

newName := stack(97,0x0333)
newName = "a̅0̳"

followed by creating the name, 

createName(newName) := <expression>

This would have the effect of manually typing/pasting a name and be fully equivalent to var1 := <expression>.

Used on the rhs, or as a function parameter, createName would not create a name but would stand in place of the name var1.

Other options might be to prefix 'newName' with an operator (eg, @ or 🄋 (or even🗃or 🗄!) - available via the ribbon) to identify a name indirection, eg

( 3 + 🄋newName == 3 _ var1)

(Suspicions that I might be subtly asking for a macro capability are, I am sure, completely unwarranted. Indeed, the thought has never so much as passed through my head …)

From a subsequent worksheet I was playing around with to create complex names, and a candidate for a function like createName,

Hi,

But, by chance, you are looking for something like this (it can be developed to make it more automatic):

I think I found a solution to the second half of my problem... that of programmatically CREATING a variable in Mathcad: AutoHotKey (https://www.autohotkey.com/). The simple example below shows a program in AutoHotKey that creates 4 variable in Mathcad when Ctrl-K is pressed. I still have a lot to figure out with regard to opening a file and parsing it in AutoHotKey, but I am confident that it can be done. This might not be the most elegant solution but  I think it will accomplish my objective. Thanks again for the suggestions.