Excel to Object GDL

[Anonymous]

Has anyone successfully updated GDL parameters, from data from an excel spreadsheet?
I gather this can be done via XML.
Just trying to find an example file to determine if and how it can be done.

[JGoode]

Tom wrote:
Thankyou,
I was referring to this but it seems to have a fixed array size of 7.
Makes me think I cannot have a pulldown box with a different size depending on the size of input text file
Tom

Here is what I use which gives a drop down box.

DIM sarray[]
! file in the library, containing parameter data
filename = "ProjectNotes.txt"
ch1 = OPEN ("text", filename, "MODE=RO, LIBRARY")
i = 1
j = 1
sarray[1] = ""
! collect all strings
DO
    n = INPUT (ch1, i, 1, var)
    IF n > 0 AND VARTYPE (var) = 2 THEN
        sarray = var
        j = j + 1
    ENDIF
    i = i + 1
WHILE n > 0
CLOSE ch1
! parameter popup with strings read from the file
VALUES "RefNote" sarray

Create RefNote as a parameter and it should work for you.