Thanks Ron! However, what if the workbook is already
open? If that is the case, when I execute the code it
actually opens the source workbook on my computer as Read-
Only...

Seth


-----Original Message-----
See this Seth
http://www.erlandsendata.no/english/vba/adodao/


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Seth" wrote in message
...
I tried posting this at the data.ado message group, but
no-one answers there!

I just want to know one thing: When creating a
connection
to an Excel workbook through ADO does this operations
actually OPEN the source workbook?!? I ask because I
keep getting problems when the source workbook is open
when I create a connection to it from another workbook.

Please help! This is all I want to know: am I able to
access an Excel workbook with ADO whether or not the
source workbook is open?

Thanks,

Seth


.