View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Mike H. Mike H. is offline
external usenet poster
 
Posts: 471
Default Read Large Array without writing in the worksheet

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...






"Daniel" wrote:

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