Variable dimension arrays?

Okay, I'm feeling like a Class A moron here, but hopefully there's some extra quirk here that I'm missing.

We're putting in a new ERP, and in the course of testing we need to be able to compare outgoing payment files with the receipt files we get back from central processing. I'm trying to take a text file that includes numerous payment batches and convert them into the payment-by-payment data in that receipt file.

Record 1: Header Information.
Record 2: Payee Data
Record 3: Accounting Info
Record 4: Payment Message
Record 5: Ad Hoc Payee Data (Optional Record)
Record 99: Batch Data

Each outgoing file includes one 99 record.
Each 99 record can include multiple 1 records. There is a matching 4 record for each 1 record, and possibly a 5 record to go with them.
Each 1 record can include multiple 2 records.

The 3 records don't really matter, since that's not in the return file.

Since I need a line in my "dummy" return file for each 2 record, I'm trying to use arrays to pull together all of my information and then reconstitute it in line-by-line form. The problem I'm running into is that the batch files can be various lengths and having various numbers of each record... and, more importantly, I can't figure out how to add the new values into what should be an empty array.

Basically, when I try adding the info, it's popping various different types of error. I've figured out that the .Add method doesn't work, but I'm also running into trouble with just adding them as values. These are the examples of how I'm structuring the addition at this point:

Please Login or Register  to view this content.

intMark99 is, obviously, an integer being used as my index. Is it the fact that my arrays were all declared with undefined dimensions? Or am I just using entirely the wrong code?

Turns out that it was the lack of a ReDim... at least the first time around.

Next question - when I ReDim an array, does it empty everything if I forget the Preserve argument? Because I literally just realized that might be why I'm returning empty arguments when I try to pull my
populated array data.

Thanks for the help from both of you!

Originally Posted by JasonLeisemann

when I ReDim an array, does it empty everything if I forget the Preserve argument?

Preserve is necessary to retain the existing values.