Subscribe Bookmark RSS Feed

Column Properties

Kevinmdaly

New Contributor

Joined:

Aug 1, 2017

I am Trying to set a column Properties from VBA. Specifically the Spec Limits Properties. When I create the column in vba i can acces its methods and properties but cant identify what propertity or method relates to the SPec Limits. Any help would be appreciated.

2 REPLIES
briancorcoran

Joined:

Jun 23, 2011

Unfortunately, there is no automation interface to column properties.  For something like that, you would need to submit a piece of JSL code using something like "RunCommand" on the application object.  The JSL would have to reference the column by name, and then get/set the spec limits using the column reference that JSL returns.

 

Brian Corcoran

JMP Development 

Kevinmdaly

New Contributor

Joined:

Aug 1, 2017

Thank you, I think i can achieve my required endpoint by using template tables with pre configured colums and spec limits.