Redimensioning/Resetting a variant array for a new loop iteration

Hi folks,

I have an add-in where I import a series of fixed-width text files do some processing of the imported data and then append the newly imported data to a workbook containing data imported from other imported text files.

More precisely,

I use a Workbooks.OpenText method to import a text file containing fixed-width data (The number of rows imported from each file can vary).
I then modify some of the data.
I then write the new data to a variant array called Transfer() using Transfer = TransRange.Value (without giving the array explicit dimensions)
I then activate an aggregate workbook containing data from previous text files and add (append) the newly imported data to the bottom of the file using
ReceiveRange = Transfer.

At this point the loop goes back to the beginning and starts the process over with another fixed-width text file. How do I prepare the Transfer array to receive another set imported data
in the next iteration? Do I need to? I could extract row and column information from the TransRange range each time, but I'd rather not if I can avoid it. Many thanks in advance for your help!!!

Erik

How about

Please Login or Register  to view this content.

Thanks very much!!!!

Thanks very much!!

Glad we could help & thanks for the feedback