Hi

I was going to start work on creating a macro to compare two sets of data for matches.

I downloaded the csv file from our CRM system (this is the file I would be comparing against)

When trying to bring it into Excel it states "File Not Loaded Completely" because the csv produces more that 65536 rows of data.

My question is is it possible to produce a macro that examines the csv file directly avoiding the 65536 problem in excel ?

If that is not possible the second question is :

Is it possible to write a macro that would compare data in several workbooks at the same time ?

Any guidance on this is appreciated.

Cheers

Jon