Hi,

I am using ADO and OLE DB to read an Excel range from a closed workbook into
a recordset that I then dump into my worksheet using the CopyFromRecordset
method.

This is similar to the methods explained on Ron De Bruins site
(http://www.rondebruin.nl/ado.htm) - and even his samples do not work on my
Windows XP / Office 2003 machine.

Strangely enough, Rons samples work fine on my Windows 2K machine with
office 2003.

But on my main dev machine (Win XP / Office 2003) I get this "catastrophic
failure" error.

Is there some change in the drivers between Windows 2000 and Windows XP that
prevents this working - and how do I get it to work? Should I reinstall the
latest MDAC?

thanks for any help

Philip