Hi all,

I have the following Data Source in ADODB.Connection:
"Data Source=D:\Book1.xls;" & _
"Extended Properties=Excel 8.0"

Is there a way to point it to the existing open Workbook with out giving the path?

"Data Source=Application.workbooks("Books("Book1.xls").W oksheets("Import").Activate;" & _
"Extended Properties=Excel 8.0"

The above example does not work, so I was wondering if any one can suggest me any solution.

Thanks for any help.