32_en-US

liliconcom

Scripting: How to get a Name object from a quoted string?Assume I have the name of a table variable as a quoted string in a run-time variable. How do I get the table variable Name object from that?

I had this same issue with table columns which I was able to work around by getting a list of table Column Names and iterating through them until I found a Name object that matched the string. Unfortunately there doesn't appear to be a function that returns table variables so this method doesn't work.

Background:
The purpose of this is to have a reusable library that can embed formulas in columns. Since the reuse code doesn't know the Table Variable Names or Column Names, I need to pass them to my functions as string parameters. However, if I use the string variable when building the formula the result is a quoted string instead of a reference to the column or table variable.