I am using Excel 97 and I am trying to get VBA to read a date (the first
field) in my stored procedure, find a matching date on the spreadsheet and
fill the new five cells in the row with some data. I am having trouble
getting the stored procedure to fill an array and then use that array to fill
the spreadsheet. I am fairly literate in VBA but if anyone can help me get
started or provide some additional information I would appreciate it.

Thanks you