Read into array and sort?

Hi,


I have a number of informations, which is shared among spreadsheets on
the same computer.

For easy exchange I want to save these with SaveSetting, and then
re-obtain with Getsetting.

But I need to have the found data sorted after obtaining them, and was
wondering how to do this?

But how?
How to sort that array after reading the data?

Dim FD(100) As Variant
For Counter = 1 to 100
FD(Counter) = GetSetting(...)
Next

And now how to sort???


Thanks in advance...

CE

Found a solution myself - sorry to borther you guys...

CE


Den 31.05.2012 09:43, Charlotte E. skrev:
> Hi,
>
>
> I have a number of informations, which is shared among spreadsheets on
> the same computer.
>
> For easy exchange I want to save these with SaveSetting, and then
> re-obtain with Getsetting.
>
> But I need to have the found data sorted after obtaining them, and was
> wondering how to do this?
>
> But how?
> How to sort that array after reading the data?
>
> Dim FD(100) As Variant
> For Counter = 1 to 100
> FD(Counter) = GetSetting(...)
> Next
>
> And now how to sort???
>
>
> Thanks in advance...
>
> CE

Charlotte E. explained :
> Hi,
>
>
> I have a number of informations, which is shared among spreadsheets on the
> same computer.
>
> For easy exchange I want to save these with SaveSetting, and then re-obtain
> with Getsetting.
>
> But I need to have the found data sorted after obtaining them, and was
> wondering how to do this?
>
> But how?
> How to sort that array after reading the data?
>
> Dim FD(100) As Variant
> For Counter = 1 to 100
> FD(Counter) = GetSetting(...)
> Next
>
> And now how to sort???
>
>
> Thanks in advance...
>
> CE

Why not dump the data into a temp wks and sort it there?

Also, instead of poluting the Registry with this data, why not 'Put' it
in a text file and 'Get' from there when you need it. You could sort
the data before 'Put'ting it into the file, or after 'Get'ting it from
the file. (Assumes using standard VB file I/O)

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion