Opening Saving Arrays in Visual Basic

[MikeMM]

I'm writing a program in VB5 where I want to save the contents of a multidimensional array and be able to open that file and fill the array with the saved data. I'm familar with how to open and save data generally but I don't know how to save an entire array all at once. Is there any method that would be more effecient than using a loop to save the data one item at a time.

thanks for your help

Mike

 

[m777182]

If your write your data array in form of spread sheet then perhaps you could use a command Workbooks(name).save or Workbooks(name).Close(SaveChanges,FileName...).It is not an ellegant way but might work.
m777182

 

[johnwm]

You might consider using a DAO recordset

Good Luck
johnwm
________________________________________________________
To get the best from these forums read faq731-376 before posting

Steam Engine enthusiasts:

http://www.essexsteam.co.uk

 

[MikeMM]

Thank you for your help guys.

Mike