This one always prompts me for Data Source.

>Hi Naomi,
>
>I have that one working too. I use that one to extract the sheet names.
>
>I use the other because I need the 'Extended Properties' to get around the PRB: Excel Values Returned as NULL Using DAO OpenRecordset (Microsoft Knowledge Base: 194124 (http://support.microsoft.com/kb/194124/EN-US/)). See also http://support.microsoft.com/kb/257819.
>
>Regards,
>Arriyel
>