I have added a variable called "AverageOfCountry" using "Variable Overview>Add" from Layout. I defined the variable using an expression. How can I evaluate the expression linked to the variable and use it in a macro? I have to use it in a macro because I need the said variable's value on every sheet of the excel document I'm exporting to.
Well it pastes me the expression string in the Excel table, not the value I would get by evaluating the expression. How do I get the variable expression to evaluate?
Another way might be to use evaluate() for the variable or maybe the expression itself - maybe like this: Re: How to export formula with Set analysis using macro
i have a similar requirement, am using a macro to export my tables into txt format and want to keep prefix as current date to that generated txt files
i used below F:\Document\$(vDate)_wang.txt --- and it is getting named as it it, it is not picking the current date, Please help me. Thanks much