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

Hi Philip

Must work OK

Do you have any missing references in the VBA editor

Alt F11
Tools>References

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Philip" <(E-Mail Removed)> wrote in message news:1E356482-2DA4-46EF-A21A-(E-Mail Removed)...
> 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

Hi,

I re-registered 'C:\WINDOWS\System32\msexcl40.dll' in the registery Editor
and now at least your examples work, so I am hopeful that was the problem ...

and so far it seems to work with my CSV and MS Excel ones too (I have
outrageous UNION and GROUP BY queries against multiple worksheets in multiple
workbooks and csv files going on ... I won't ruin your day with the details!)

I got the solution after seeing another error message about 'Could not find
installable ISAM'

so thanks anyway !

Philip

"Ron de Bruin" wrote:

> Hi Philip
>
> Must work OK
>
> Do you have any missing references in the VBA editor
>
> Alt F11
> Tools>References
>
> --
>
> Regards Ron de Bruin
> http://www.rondebruin.nl/tips.htm
>
>
> "Philip" <(E-Mail Removed)> wrote in message news:1E356482-2DA4-46EF-A21A-(E-Mail Removed)...
> > 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
>

Thanks for posting back with the fix

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Philip" <(E-Mail Removed)> wrote in message news:9E4D4541-C15E-42E5-A186-(E-Mail Removed)...
> Hi,
>
> I re-registered 'C:\WINDOWS\System32\msexcl40.dll' in the registery Editor
> and now at least your examples work, so I am hopeful that was the problem ...
>
> and so far it seems to work with my CSV and MS Excel ones too (I have
> outrageous UNION and GROUP BY queries against multiple worksheets in multiple
> workbooks and csv files going on ... I won't ruin your day with the details!)
>
> I got the solution after seeing another error message about 'Could not find
> installable ISAM'
>
> so thanks anyway !
>
> Philip
>
> "Ron de Bruin" wrote:
>
>> Hi Philip
>>
>> Must work OK
>>
>> Do you have any missing references in the VBA editor
>>
>> Alt F11
>> Tools>References
>>
>> --
>>
>> Regards Ron de Bruin
>> http://www.rondebruin.nl/tips.htm
>>
>>
>> "Philip" <(E-Mail Removed)> wrote in message news:1E356482-2DA4-46EF-A21A-(E-Mail Removed)...
>> > 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
>>