ADODB Recordset
 

When I try to create a connection to an Excel workbook it
tells me that the workbook is already open...i.e.:

RS.Open SQL, Connection

If the workbook defined in the connection string is open
then I get a prompt...

Can I get around this?

Thanks,

Seth