Passing Values between Datasheets

[tdevick]

If I understand correctly, you have a data sheet cell with the name "pUsername" and it contains the formula "Global!A1". You want to read this value and change it to "Global!pUsername". Is that correct?

Code:

DataTable.GetSheet("Global").GetParameter(i).Name

where "i" is a cell index. So if you want to get the name of cell 1 of the current row in a datasheet, you would do this:

Code:

cellName=DataTable.GetSheet("Global").GetParameter(1).Name

assuming the title of cell #1 in row x in the global sheet of your data table has title "pUsername", if I understand you correctly, you would do this:

Code:

formula=DataTable(1, dtGlobalSheet) ' returns the string "Global!A1"
tempTable=split(formula, "!")
newFormula=tempTable(0) & "!" & cellName ' returns "Global!pUsername"

Is this what you were looking for, or am I misunderstanding your goal?