VBA - save Array to use after close

[Kamolga]

Hi,

I am a basic user of arrays. I build a 2d array "IDarr"

ReDim IDarr(1 To r, 1 To 3) As Variant          
          'Column 1 is Project task Name with unique ID
          IDarr(r, 1) = ThisProject.Name & "_" & iTask.UniqueID
          'Column 2 is Outlook Calendar ID
          IDarr(r, 2) = OtlAppointment.GlobalAppointmentID

Is there a way to declare it so that the records are saved with the file (rather than variant inside the macro) so that I can use them when when re-open the file?

 

[Fluff]

You would need to write the array to a worksheet.