Thread: Array vs. Cells
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Robin Clay[_4_] Robin Clay[_4_] is offline
external usenet poster
 
Posts: 40
Default Array vs. Cells

Greetings !

"RB Smissaert" wrote:

I don't need to put the data into the spreadsheet

Do you need an array then? How about just comparing 2 variables?


Well, I have to compare each file from my back-up store (on CDs) with over
50,000 *.CHK files

So I thought I would read in the data from those 50,000+ and put it into an
array or into spreadsheet cells, and then fetch the same data from the backup
files, one by one, and compare it with the array / cells.

In any case variables or array will be faster then sheet.


Ah ! Thank you !

The answer to my question ;)

But I remain open to suggestions !


Thanks again for responding.

--
Regards

Robin
Robin_B DOT Clay AT virgin DOTnet
In the Blackmore Vale, Dorset.