cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

MATHCAD + EXCEL VBA Subscripts

ptc-5239207
1-Newbie

MATHCAD + EXCEL VBA Subscripts

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

0 REPLIES 0
Top Tags