View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GS[_2_] GS[_2_] is offline
external usenet poster
 
Posts: 3,514
Default Read into array and sort?

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