I have developed VBA classes under an Excel 2000 workbook that import
data from MS Project 98. These currently iterate through each task in
the project and writes the task information to cells in the workbook.
The plans are several thousands task long and so the import process is
quite slow. Is there a quicker way of doing this (like DAO?).

One constraint that I have is that other users need to be able to use
their own copies of the workbook and these people may be using Excel 97
or 2000 and MS Project 98 or 2000 or combinations thereof.

Thanks in anticipation.