Skip to main content
1-Visitor
September 2, 2013
Question

MATHCAD + EXCEL VBA Subscripts

  • September 2, 2013
  • 0 replies
  • 2764 views

Hello,

My question is similar to that asked here but not quite:

http://communities.ptc.com/message/187420#187420

I am writing VBA macro to get a value from a MATHCAD worksheet using the OLE object interface with the getValue method.

My question is, is it possible to get variables with literal subscript names. That is, if I had a statement like:

x.1 := 1

how would I use the getValue method to retrieve the value of x.1?

getValue("x.1") does not work however if I ditch the subscript the method works fine. I am hoping there is a simple trick or work around so I dont have to redefine my variables.

Appreciate your help.

Regards Jacob