Read Large Array without writing in the worksheet

[Guest]

Hello,
I have two large arrays in two separate external text files (values
separated by a space):
A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array
C(82000,240).

How can I read it in VBA without the need to write it on the worksheet and
print C in worksheets: result1 (65536,240) and result2 (65537,240)

Thanks and good weekend

 

[Alan Beban]

Hello,
I have two large arrays in two separate external text files (values
separated by a space):
A(82000,1500), B(1500, 240). Need to do the MMULT. Resulting array
C(82000,240).

How can I read it in VBA without the need to write it on the worksheet and
print C in worksheets: result1 (65536,240) and result2 (65537,240)

Thanks and good weekend

What version of Excel?

Alan Beban

 

[Guest]

I think you are so close to what you want that you don't realize that most
people may have no idea what you are asking for. Can you give some example
of what you need to do like this:

File1
100 200
200 10
300 4
5 77

File2
44 323
1 22
33 44

Now what do you wish to do? Multiple like this:
File 1
100* 200
200 *10
300 *4
5 *77

File 2:
44* 323
1* 22
33* 44

and then write back into file the product of:
100* 200*44* 323
200 *10*1* 22
....etc....
Please be more explicit in what you want to end up in your "C" as you call
it. Do you want it in a spreadsheet or do you want to just store the product
of each multiplication in a new file "C"? Let me know...

 

[Guest]

2003

What version of Excel?

Alan Beban

 

[Guest]

here it goes,

A(82000,1500), B(1500,240)
want to do C=A*B, where C(82000,240)

A look like:

A

7.68053e-03 1.14077e-02 1.34675e-02 ... (1500 numbers separated by space
in a row)
....
82000 rows of 1500 each

B similar but different size

want to read each array into A(i,j), B(l,m)
and compute C(i,m)

then write C into 2 worksheets (cant be one because of the nr of rows)

hope is more clear, thanks Mike,
looking for feedback