I am using VB to read the excel file which has got some 40000 rows. Once it finishes reading all those rows applicaiton hangs(not responding) message will come.
Please let me know how to over come this situation. And how to optimize the performace of reading excel rows, since it is taking lot of time to read 40000 rows.
VB - 6.0
Excel - Office -97.
Thanks in advance.