array parameter

[lespaul]

I searched and found some information on passing arrays, but not what I'm looking for.

In my procedure I create a variant array

ProcessList := VarArrayCreate([0, (personcount - 1), 0, 8], varOleStr);

I then fill this array with information and pass it to excel to print a specific report. I now need to pass this array to another procedure in order to create a text file, something like:

procedure CreateTextTransfer(arrProcessList : variant);
begin
//create my file
end;


CreateTextTransfer(ProcessList);

Will something like this work? Will I be able to access the array elements in the CreateTextTransfer procedure if I set it up like this?

Thanks!

Leslie

 

[lespaul]

actually after reviewing the process I found that I don't need to pass this array! Thanks for looking.

Leslie

 

[lespaul]

Ok, I figured out what I need to do. In my excel process, I create a comma separated list of the unique ID of the people who are getting paid (I remove the people with no pay which is why the process list won't work, it still has people with no pay). After I create the comma separated list in Excel, I transfer that back to Delphi:

PaidJurorList := TStringList.Create;
  PaidJurorList.CommaText := excelapp.Worksheets.Item['Criteria'].Range['jurorlist'];

In order to create the text file I need to loop through the string list and for each jurorid (the unique field) get the information from the ProcessList array where the jurorid's match.

Is this possible?

Thanks again.

Leslie