Hello,
I'm looking for the right ADO connection string to use inside a Excel workbook (with VBA) to another workbook with a "workbook password".
I'm using this connection string, and it works only when the workbook is without the password
Is it possible ?
Thank you.
I'm looking for the right ADO connection string to use inside a Excel workbook (with VBA) to another workbook with a "workbook password".
I'm using this connection string, and it works only when the workbook is without the password
VBA Code:
"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & MyPath & ";Extended Properties=""Excel 12.0;HDR=YES"";"
Is it possible ?
Thank you.