Copy variable

[jduenyas]

Hello gurus

I have created a new document with a Binary load from an existing one.

However, variables are not being copied/transferred with the Binary load.

Is there a way to copy all variables (i have many of them) from the existing document to the new?

Thanks

[petter]

Yes - and if you read the link that Rob suggested you will find code to do exactly that.

Quoting from his post it will look like this:

FOR idx=0 to NoOfRows('VARIABLE')-1
 LET vVarname = Peek('Name',$(idx),'VARIABLE');
 LET [$(vVarname)] = Peek('RawValue',$(idx),'VARIABLE');
NEXT idx

SET idx=;
SET vVarname=;
DROP Table VARIABLE;

[jduenyas]

In any of the sheets type

<Ctrl><Alt> v this will open a dialog box to create variables. Click Add, name your variable and then enter the formula/reference/fields that you would like to use in a variable name.

Did this help?